{"text_format":"3","workbook":"xls","n_sheets":22,"sheets":["ЦЕХ","Освещение","Нагр 0,4","Защ.аппар до 1кВ","Ф202-90-0,4","Потери цех тр-ров","6 кВ","Ф202-90-6кВ","Картограмма","Потери ГПП","ТЭР","КЗ 6-10 по ТП","ударный коэф10 kb","КЗ 0,4 по ТП","ударный 0,4 кВ","Кабели","Потери напряжения в КЛ","Выключатели 6+ТТ","Шины","Экономика","РЗ","Заземление"],"not_rendered":{"images":24,"external_links":2,"defined_names":7},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"ЦЕХ","index":0,"n_rows":35,"n_cols":16,"rows_kept":35,"merged":[[0,0,0,14],[1,0,1,14],[2,0,2,6],[2,7,2,8],[2,9,5,9],[2,10,5,10],[2,11,5,11],[2,12,2,14],[3,0,3,3],[3,4,3,6],[3,7,4,7],[3,8,4,8],[3,12,4,12],[3,13,4,13],[3,14,4,14],[4,0,5,0],[4,1,5,1],[4,2,4,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[7,0,7,14],[13,0,13,14],[21,0,21,14],[24,0,24,14],[28,0,28,14]],"flags":["formulas_cached_only"]}
["Таблица 3.1"]
["         Электрические нагрузки до 1000В цеха металлоизделий"]
["Исходные данные",{"$nulls":6},"Расчетные величины",null,"n*Pн^2","Эффективн. число эл.приемн.   nэ","Коэф. расчетной нагрузки Кр","Расчет. мощность"]
["По заданию технологов",{"$nulls":3},"По справочным данным",null,null,"Активная мощность  ","Реактивная,  ",{"$nulls":3},"Активная Р мах","Реактивная, Qмах","Полная, Sмах"]
["Наименование      электроприемников и узлов питания","Кол-во ЭП, шт n","Установленная мощность, кВт",null,"Коэффициент использов    Ки","соs","tq",{"$nulls":8},"Расчетный ток"]
[null,null,"одного ЭП, p","общая Р=n*p",{"$nulls":3},"Рпр=Ки*р  кВт","Qпр=Ки*р*tg, кВАр",{"$nulls":3},"кВт","кВАр","кВА","А"]
[2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["ШРA-1"]
["Кран мостовой (1)",1,25,25,0.3,0.5,{"v":1.7320508075688767,"d":"1.73"},{"v":7.5,"d":"7.50"},{"v":12.990381056766577,"d":"12.99"},625]
["Продольно строгальные станки (2,3)",2,12.2,24.4,0.6,0.645,{"v":1.184779177998564,"d":"1.18"},{"v":14.639999999999999,"d":"14.64"},{"v":17.345167165898975,"d":"17.35"},{"v":297.67999999999995,"d":"298"}]
["Токарно-револьверные станки (4-8)",5,3.5,17.5,0.2,0.5,{"v":1.7320508075688767,"d":"1.73"},{"v":3.5,"d":"3.50"},{"v":6.062177826491069,"d":"6.06"},{"v":61.25,"d":"61"}]
["Токарные станки (9-13) ",5,15,75,0.2,0.5,{"v":1.7320508075688767,"d":"1.73"},{"v":15,"d":"15.00"},{"v":25.980762113533153,"d":"25.98"},1125]
["Итого ШРА-1",13,"3,5-25",141.9,{"v":0.2863988724453841,"d":"0.29"},{"v":0.5458754781801878,"d":"0.55"},{"v":1.5349037441606734,"d":"1.5"},{"v":40.64,"d":"40.6"},{"v":62.37848816268977,"d":"62.4"},{"v":2108.93,"d":"2108.9"},{"v":9.547784895657989,"d":"10"},1.13,{"v":45.923199999999994,"d":"45.9"},{"v":68.61633697895876,"d":"68.6"},{"v":82.56598572444965,"d":"82.6"},{"v":125.4460370629416,"d":"125.4"}]
["ШРА-2"]
["Продольно-строгальный станок (14)",1,12.2,12.2,0.6,0.645,{"v":1.184779177998564,"d":"1.18"},{"v":7.319999999999999,"d":"7.32"},{"v":8.672583582949487,"d":"8.67"},{"v":148.83999999999997,"d":"149"}]
["Плоскошлифовальные станки (15-17) ",3,3,9,0.2,0.5,{"v":1.7320508075688767,"d":"1.73"},{"v":1.8,"d":"1.80"},{"v":3.117691453623978,"d":"3.12"},27]
["Вертикально-сверлиль-ные станки (18,19)",2,2.5,5,0.2,0.5,{"v":1.7320508075688767,"d":"1.73"},{"v":1,"d":"1.00"},{"v":1.7320508075688767,"d":"1.73"},{"v":12.5,"d":"13"}]
["Расточной станок (20)",1,13,13,0.2,0.5,{"v":1.7320508075688767,"d":"1.73"},{"v":2.6,"d":"2.60"},{"v":4.5033320996790795,"d":"4.50"},169]
["Фрезерные станки (21,22)",2,3.8,7.6,0.2,0.5,{"v":1.7320508075688767,"d":"1.73"},1.52,{"v":2.632717227504693,"d":"2.63"},{"v":28.88,"d":"29"}]
["Радиально-сверлильные станки (23,24)",2,9.5,19,0.2,0.5,{"v":1.7320508075688767,"d":"1.73"},{"v":3.8000000000000003,"d":"3.80"},{"v":6.5817930687617325,"d":"6.58"},{"v":180.5,"d":"181"}]
["Итого ШРA-2",11,"2,5-12,2",65.80000000000001,{"v":0.27416413373860177,"d":"0.27"},{"v":0.5521524790328192,"d":"0.55"},{"v":1.5099871529982178,"d":"1.51"},18.04,{"v":27.240168240087847,"d":"27.2"},{"v":566.72,"d":"566.7"},{"v":7.639822134387353,"d":"8"},{"v":1.277,"d":"1.28"},{"v":23.037079999999996,"d":"23.0"},{"v":29.964185064096633,"d":"30.0"},{"v":37.796288726299984,"d":"37.8"},{"v":57.42551965920557,"d":"57.4"}]
["ШРA-3"]
["Токарно-револьверные станки (32-35,39-41) ",7,3.5,24.5,0.2,0.5,{"v":1.7320508075688767,"d":"1.73"},{"v":4.9,"d":"4.90"},{"v":8.487048957087497,"d":"8.49"},{"v":85.75,"d":"86"}]
["Итого ШРA-3",7,"3,5",24.5,{"v":0.2,"d":"0.20"},{"v":0.5000000000000001,"d":"0.50"},{"v":1.7320508075688767,"d":"1.73"},{"v":4.9,"d":"4.90"},{"v":8.487048957087497,"d":"8.5"},{"v":85.75,"d":"85.8"},7,1.54,{"v":7.546000000000001,"d":"7.5"},{"v":9.335753852796248,"d":"9.3"},{"v":12.004099966261528,"d":"12.0"},{"v":18.23834301815861,"d":"18.2"}]
["ШР-1"]
["Электрические индукционные печи (26, 27) ",2,24,48,0.7,0.95,{"v":0.3286841051788632,"d":"0.33"},{"v":33.599999999999994,"d":"33.60"},{"v":11.043785934009803,"d":"11.04"},1152]
["Кран мостовой (31) ",1,25,25,0.3,0.5,{"v":1.7320508075688767,"d":"1.73"},{"v":7.5,"d":"7.50"},{"v":12.990381056766577,"d":"12.99"},625]
["Итого ШР-1",3,"24-25",73,{"v":0.563013698630137,"d":"0.56"},{"v":0.863237536921131,"d":"0.86"},{"v":0.5847729194836102,"d":"0.58"},{"v":41.099999999999994,"d":"41.10"},{"v":24.034166990776377,"d":"24.0"},{"v":1777,"d":"1777.0"},{"v":2.9988745075970735,"d":"3"},{"v":1.268,"d":"1.27"},{"v":52.114799999999995,"d":"52.1"},{"v":26.437583689854016,"d":"26.4"},{"v":58.437130408654,"d":"58.4"},{"v":88.78603413712014,"d":"88.8"}]
["ШР-2"]
["Вентиляторы (36-38) ",3,5,15,0.95,0.87,{"v":0.566726116580278,"d":"0.57"},14.25,{"v":8.075847161268962,"d":"8.08"},75]
["Кран мостовой (42)",1,25,25,0.3,0.5,{"v":1.7320508075688767,"d":"1.73"},{"v":7.5,"d":"7.50"},{"v":12.990381056766577,"d":"12.99"},625]
["Итого ШР-2",4,"5-25",40,{"v":0.54375,"d":"0.54"},{"v":0.7183076284512088,"d":"0.72"},{"v":0.9685622169211743,"d":"0.97"},21.75,{"v":21.06622821803554,"d":"21.1"},{"v":700,"d":"700.0"},{"v":2.2857142857142856,"d":"2"},{"v":1.438,"d":"1.44"},{"v":31.2765,"d":"31.3"},{"v":23.172851039839095,"d":"23.2"},{"v":38.92557613657853,"d":"38.9"},{"v":59.1412943705655,"d":"59.1"}]
["Электрическая печь сопротивления (25) ",1,60,60,0.5,0.85,{"v":0.6197443384031023,"d":"0.62"},{"v":30,"d":"30.00"},{"v":18.59233015209307,"d":"18.59"},3600,{"$nulls":4},{"v":35.294117647058826,"d":"35.3"},{"v":53.62386401142036,"d":"53.6"}]
["Электродуговые печи (28-30)",3,50,150,0.6,0.8,{"v":0.7499999999999998,"d":"0.75"},{"v":90,"d":"90.00"},{"v":67.49999999999999,"d":"67.50"},7500,{"$nulls":4},{"v":112.49999999999999,"d":"112.5"},{"v":170.92606653640235,"d":"170.9"}]
["ИТОГО цех металлоиздел.",42,"2,5-60",555.2,{"v":0.4438580691642651,"d":"0.44"},{"v":0.7320960304537238,"d":"0.73"},{"v":0.9304809914408556,"d":"0.93"},246.43,{"v":229.29843072077006,"d":"229.3"},{"v":16338.4,"d":"16338"},{"v":18.866415316065222,"d":"19"},0.85,{"v":209.4655,"d":"209.5"},{"v":229.29843072077006,"d":"229.3"},{"v":310.5697442141745,"d":"310.6"},{"v":471.8619090110707,"d":"471.9"}]

{"sheet":"Освещение","index":1,"n_rows":17,"n_cols":13,"rows_kept":17,"merged":[[45,0,46,0]],"flags":["formulas_cached_only"]}
[" Таблица 3.2"]
["              Расчет электрического освещения"]
["Наименование цеха","Длина А, м ","Ширина В, м","Освещеность Е, лк","Тип светильника","Высота Н, м ","Руд  Вт/м2","Площадь S, м2","Кзап","К спроса Кс","Мощность установл.Руст, кВт","Мощность расчетн.активная  Ррасч, кВт","Мощность расчетн.реактивная Qрасч,кВАр"]
["1. Сборочный цех",84,84,200,"УПДДРЛ-400",15,{"v":10.4,"d":"10.40"},7056,1.5,0.85,{"v":80.72064000000002,"d":"80.72"},{"v":102.91881600000002,"d":"102.92"},{"v":49.845857592539666,"d":"49.85"}]
["2. Склады",92,48,100,"УПДДРЛ-400",13,{"v":5.2,"d":"5.20"},4416,1.3,0.6,{"v":25.259520000000006,"d":"25.26"},{"v":19.702425600000005,"d":"19.70"},{"v":9.542320237003192,"d":"9.54"}]
["3. Цех сборки электрических машин  ",92,60,300,"УПДДРЛ-400",14,{"v":15.6,"d":"15.60"},5520,1.5,0.95,{"v":94.72319999999999,"d":"94.72"},{"v":134.98056,"d":"134.98"},{"v":65.37406893139205,"d":"65.37"}]
["4. Цех механического оборудования",48,48,300,"УПДДРЛ-400",13,{"v":15.6,"d":"15.60"},2304,1.5,0.85,{"v":39.53664,"d":"39.54"},{"v":50.409216,"d":"50.41"},{"v":24.414297596345953,"d":"24.41"}]
["5. Кузнечный цех",60,48,200,"C35ДРЛ-400",12,{"v":8.8,"d":"8.80"},2880,1.8,0.85,{"v":27.878400000000006,"d":"27.88"},{"v":42.65395200000001,"d":"42.65"},{"v":20.658251812292736,"d":"20.66"}]
["6. Литейный цех  ",92,48,300,"РСП-08",13,{"v":13.2,"d":"13.20"},4416,1.8,0.95,{"v":64.12032,"d":"64.12"},{"v":109.6457472,"d":"109.65"},{"v":53.10385907042308,"d":"53.10"}]
["7. Компрессорая",60,24,150,"УПДДРЛ-400",9,{"v":9.3,"d":"9.30"},1440,1.5,0.85,{"v":14.731200000000003,"d":"14.73"},{"v":18.782280000000004,"d":"18.78"},{"v":9.096673383253902,"d":"9.10"}]
["8. Цех наладки и автоматики",92,48,200,"УПДДРЛ-400",13,{"v":10.4,"d":"10.40"},4416,1.5,0.95,{"v":50.51904000000001,"d":"50.52"},{"v":71.98963200000001,"d":"71.99"},{"v":34.86617009674243,"d":"34.87"}]
["9.Термический цех",92,48,200,"РСП-08",12,{"v":8.8,"d":"8.80"},4416,1.8,0.95,{"v":42.746880000000004,"d":"42.75"},{"v":73.09716480000002,"d":"73.10"},{"v":35.40257271361539,"d":"35.40"}]
["10. Сварочный цех",54,48,300,"РСП-08",14,{"v":13.2,"d":"13.20"},5832,1.8,0.85,{"v":84.68064,"d":"84.68"},{"v":129.5613792,"d":"129.56"},{"v":62.74943987983917,"d":"62.75"}]
["11.Административно-бытовой корпус",48,48,150,"ЛБ-40",8,{"v":5.4,"d":"5.40"},2304,1.3,0.6,{"v":13.685760000000002,"d":"13.69"},{"v":10.6748928,"d":"10.67"},{"v":5.170086549814437,"d":"5.17"}]
["12. Цех металлоизделий",48,30,200,"РСП-08",12,10.2,1440,2,0.95,{"v":16.1568,"d":"16.16"},{"v":30.69792,"d":"30.70"},{"v":14.86768122854401,"d":"14.87"}]
["Освещение территории","-","-",50,"УПДДРЛ-400",12,{"v":2.6,"d":"2.60"},140000,1,0.6,{"v":400.40000000000003,"d":"400.40"},240.24,{"v":116.3535424662457,"d":"116.35"}]
["ИТОГО ","-","-","-","-","-",{"v":128.70000000000002,"d":"128.70"},185000,"-","-",{"v":955.15904,"d":"955.16"},{"v":1035.3539856,"d":"1035.35"},{"v":501.4448215580517,"d":"501.44"}]

{"sheet":"Нагр 0,4","index":2,"n_rows":58,"n_cols":17,"rows_kept":58,"merged":[[0,0,0,14],[1,0,1,14],[2,0,2,7],[2,8,2,9],[2,10,5,10],[2,11,5,11],[2,12,2,14],[2,15,5,15],[3,0,3,4],[3,5,3,7],[3,8,4,8],[3,9,4,9],[3,12,5,12],[3,13,5,13],[3,14,5,14],[3,14,5,14],[4,0,5,0],[4,1,5,1],[4,2,4,4],[4,5,5,5],[4,6,4,7],[7,0,7,14],[11,0,11,14],[11,17,11,31],[11,17,11,31],[23,0,23,14],[28,0,28,14],[32,0,32,14],[36,0,36,14],[40,0,40,14],[44,0,44,14],[48,0,48,14],[52,0,52,14]],"flags":["formulas_cached_only"]}
["Таблица 3.3"]
["                 Электрические нагрузки завода до 1000В"]
["Исходные данные",{"$nulls":7},"Расчетные величины",null,"Эффективн. число эл.приемн.   nэ","Коэф. расчетной нагрузки Кр","Расчетная мощность",null,null,"Ток расчетный"]
["По заданию технологов",{"$nulls":4},"По справочным данным",null,null,"Активная мощность  ","Реактивная мощность  ",null,null,"Актив-ная      Р мах","Реактив-ная,     Qмах","Полная, Sмах"]
["Наименование      ЭП","Кол-воЭП, шт n","Номинальная (установленная) мощность, кВт",null,null,"Коэффициент использов    Ки","Коэ-т реактивной мощности"]
[null,null,"одного ЭП Рмин, кВт","одного ЭП  Рмах, кВт","общая Руст, кВт",null,"соs","tq","Рпр=Ки*р  кВт","Qпр=Ки*р*tg, кВАр"]
[1,2,3,4,null,5,6,7,8,9,10,11,12,13,14]
["1. Сборочный цех"]
["Силовая нагрузка ",80,{"v":5,"d":"5.0"},{"v":75,"d":"75.0"},{"v":1800,"d":"1800.0"},{"v":0.4,"d":"0.40"},{"v":0.7,"d":"0.70"},{"v":1.020204061220407,"d":"1.02"},{"v":720,"d":"720.0"},{"v":734.5469240786931,"d":"734.5"},48,{"v":0.7,"d":"0.70"},{"v":503.99999999999994,"d":"504.0"},{"v":734.5469240786931,"d":"734.5"}]
["Электрич.освещ.",{"$nulls":3},{"v":80.72064000000002,"d":"80.7"},{"$nulls":3},{"v":102.91881600000002,"d":"102.9"},{"v":49.845857592539666,"d":"49.8"},null,null,{"v":102.91881600000002,"d":"102.9"},{"v":49.845857592539666,"d":"49.8"}]
["Итого сборочный цех",80,"5",{"v":75,"d":"75.0"},{"v":1880.72064,"d":"1880.7"},{"v":0.43755505123823174,"d":"0.44"},{"v":0.7238476877495854,"d":"0.72"},{"v":0.9531836754978669,"d":"0.95"},{"v":822.918816,"d":"822.9"},{"v":784.3927816712328,"d":"784.4"},48,{"v":0.7,"d":"0.70"},{"v":606.918816,"d":"606.9"},{"v":784.3927816712328,"d":"784.4"},{"v":991.7774373077742,"d":"991.8"},{"v":1508.6361991295623,"d":"1508.64"}]
["2.Склады                   \n"]
["Силовая нагрузка ",19,{"v":4,"d":"4.0"},{"v":80,"d":"80.0"},{"v":589,"d":"589.0"},{"v":0.3,"d":"0.30"},0.65,{"v":1.1691295502746664,"d":"1.17"},176.7,{"v":206.58519153353353,"d":"206.6"},{"v":14.725,"d":"15"},0.85,{"v":150.195,"d":"150.2"},{"v":206.58519153353353,"d":"206.6"}]
["Электрич.освещ.",{"$nulls":3},{"v":25.259520000000006,"d":"25.3"},{"$nulls":3},{"v":19.702425600000005,"d":"19.7"},{"v":9.542320237003192,"d":"9.5"},null,null,{"v":19.702425600000005,"d":"19.7"},{"v":9.542320237003192,"d":"9.5"}]
["Итого склады   ",19,{"v":4,"d":"4.0"},{"v":80,"d":"80.0"},{"v":614.25952,"d":"614.3"},{"v":0.3197385131287831,"d":"0.32"},{"v":0.6725281761907027,"d":"0.67"},{"v":1.1004319886084786,"d":"1.10"},{"v":196.4024256,"d":"196.4"},{"v":216.12751177053673,"d":"216.1"},{"v":14.725,"d":"15"},0.85,{"v":169.8974256,"d":"169.9"},{"v":216.12751177053673,"d":"216.1"},{"v":274.91132492065697,"d":"274.9"},{"v":418.1796850025205,"d":"418.18"}]
["3. Цех сборки электрических машин"]
["Силовая нагрузка ",160,1.5,{"v":90,"d":"90.0"},{"v":2740,"d":"2740.0"},0.35,{"v":0.8,"d":"0.80"},{"v":0.7499999999999998,"d":"0.75"},{"v":958.9999999999999,"d":"959.0"},{"v":719.2499999999997,"d":"719.3"},{"v":60.888888888888886,"d":"61"},{"v":0.7,"d":"0.70"},{"v":671.2999999999998,"d":"671.3"},{"v":719.2499999999997,"d":"719.3"}]
["Электрич.освещ.",{"$nulls":3},{"v":94.72319999999999,"d":"94.7"},{"$nulls":3},{"v":134.98056,"d":"135.0"},{"v":65.37406893139205,"d":"65.4"},null,null,{"v":134.98056,"d":"135.0"},{"v":65.37406893139205,"d":"65.4"}]
["Итого цех сборки электрических машин",160,1.5,{"v":90,"d":"90.0"},{"v":2834.7232,"d":"2834.7"},{"v":0.3859214755077321,"d":"0.39"},{"v":0.8126044117650134,"d":"0.81"},{"v":0.7172193891008372,"d":"0.72"},{"v":1093.98056,"d":"1094.0"},{"v":784.6240689313917,"d":"784.6"},{"v":60.888888888888886,"d":"61"},{"v":0.7,"d":"0.70"},{"v":806.2805599999998,"d":"806.3"},{"v":784.6240689313917,"d":"784.6"},{"v":1125.0436751434881,"d":"1125.0"},{"v":1711.3533239176882,"d":"1711.35"}]
["4. Цех механического оборудования"]
["Силовая нагрузка ",67,{"v":4,"d":"4.0"},{"v":36,"d":"36.0"},{"v":1020,"d":"1020.0"},{"v":0.4,"d":"0.40"},{"v":0.7,"d":"0.70"},{"v":1.020204061220407,"d":"1.02"},{"v":408,"d":"408.0"},{"v":416.2432569779261,"d":"416.2"},{"v":56.666666666666664,"d":"57"},{"v":0.7,"d":"0.70"},{"v":285.59999999999997,"d":"285.6"},{"v":416.2432569779261,"d":"416.2"}]
["Электрич. освещ.",{"$nulls":3},{"v":39.53664,"d":"39.5"},{"$nulls":3},{"v":50.409216,"d":"50.4"},{"v":24.414297596345953,"d":"24.4"},null,null,{"v":50.409216,"d":"50.4"},{"v":24.414297596345953,"d":"24.4"}]
["Итого цех механического оборудования",67,{"v":4,"d":"4.0"},{"v":36,"d":"36.0"},{"v":1059.53664,"d":"1059.5"},{"v":0.4326506500048927,"d":"0.43"},{"v":0.720927768533691,"d":"0.72"},{"v":0.9612755136543154,"d":"0.96"},{"v":458.409216,"d":"458.4"},{"v":440.657554574272,"d":"440.7"},{"v":56.666666666666664,"d":"57"},{"v":0.7,"d":"0.70"},{"v":336.009216,"d":"336.0"},{"v":440.657554574272,"d":"440.7"},{"v":554.149143859586,"d":"554.1"},{"v":842.9405899902434,"d":"842.94"}]
["5. Кузнечный цех"]
["Силовая нагрузка ",80,{"v":8,"d":"8.0"},{"v":70,"d":"70.0"},{"v":2340,"d":"2340.0"},0.55,0.75,{"v":0.8819171036881968,"d":"0.88"},{"v":1287,"d":"1287.0"},{"v":1135.0273124467092,"d":"1135.0"},{"v":66.85714285714286,"d":"67"},0.77,{"v":990.99,"d":"991.0"},{"v":1135.0273124467092,"d":"1135.0"}]
["Освещение ",{"$nulls":3},{"v":27.878400000000006,"d":"27.9"},{"$nulls":3},{"v":42.65395200000001,"d":"42.7"},{"v":20.658251812292736,"d":"20.7"},null,null,{"v":42.65395200000001,"d":"42.7"},{"v":20.658251812292736,"d":"20.7"}]
["Итого кузнечный\n",80,{"v":8,"d":"8.0"},{"v":70,"d":"70.0"},{"v":2367.8784,"d":"2367.9"},{"v":0.5615381060108492,"d":"0.56"},{"v":0.7547559473154246,"d":"0.75"},{"v":0.8691626588411793,"d":"0.87"},{"v":1329.6539520000001,"d":"1329.7"},{"v":1155.685564259002,"d":"1155.7"},{"v":66.85714285714286,"d":"67"},0.77,{"v":1033.6439520000001,"d":"1033.6"},{"v":1155.685564259002,"d":"1155.7"},{"v":1550.4931289569863,"d":"1550.5"},{"v":2358.5231654350264,"d":"2358.52"}]
["Продолжение таблицы 3.1"]
["6. Литейный цех              \n"]
["Силовая нагрузка ",145,{"v":2,"d":"2.0"},{"v":120,"d":"120.0"},{"v":1730,"d":"1730.0"},{"v":0.6,"d":"0.60"},0.75,{"v":0.8819171036881968,"d":"0.88"},{"v":1038,"d":"1038.0"},{"v":915.4299536283482,"d":"915.4"},{"v":28.833333333333332,"d":"29"},{"v":0.8,"d":"0.80"},{"v":830.4000000000001,"d":"830.4"},{"v":915.4299536283482,"d":"915.4"}]
["Электрич.освещ.",{"$nulls":3},{"v":64.12032,"d":"64.1"},{"$nulls":3},{"v":109.6457472,"d":"109.6"},{"v":53.10385907042308,"d":"53.1"},null,null,{"v":109.6457472,"d":"109.6"},{"v":53.10385907042308,"d":"53.1"},null,null,0]
["Итого литейный",145,{"v":2,"d":"2.0"},{"v":120,"d":"120.0"},{"v":1794.12032,"d":"1794.1"},{"v":0.6396704470745864,"d":"0.64"},{"v":0.7642233067758397,"d":"0.76"},{"v":0.8439309909541146,"d":"0.84"},{"v":1147.6457472,"d":"1147.6"},{"v":968.5338126987713,"d":"968.5"},{"v":28.833333333333332,"d":"29"},{"v":0.8,"d":"0.80"},{"v":940.0457472,"d":"940.0"},{"v":968.5338126987713,"d":"968.5"},{"v":1349.7198795193117,"d":"1349.7"},{"v":2053.1181617269726,"d":"2053.12"}]
["7. Компрессорная"]
["Силовая нагрузка ",28,0.8,{"v":16,"d":"16.0"},{"v":200,"d":"200.0"},{"v":0.8,"d":"0.80"},0.95,{"v":0.3286841051788632,"d":"0.33"},{"v":160,"d":"160.0"},{"v":52.58945682861811,"d":"52.6"},25,0.85,{"v":136,"d":"136.0"},{"v":52.58945682861811,"d":"52.6"}]
["Электрич.освещ.",{"$nulls":3},{"v":14.731200000000003,"d":"14.7"},{"$nulls":3},{"v":18.782280000000004,"d":"18.8"},{"v":9.096673383253902,"d":"9.1"},null,null,{"v":18.782280000000004,"d":"18.8"},{"v":9.096673383253902,"d":"9.1"}]
["Итого компресорная",28,0.8,{"v":16,"d":"16.0"},{"v":214.7312,"d":"214.7"},{"v":0.8325864150156103,"d":"0.83"},{"v":0.9453125621678496,"d":"0.95"},{"v":0.34503492299053357,"d":"0.35"},{"v":178.78228000000001,"d":"178.8"},{"v":61.68613021187201,"d":"61.7"},25,0.85,{"v":154.78228000000001,"d":"154.8"},{"v":61.68613021187201,"d":"61.7"},{"v":166.62152580778522,"d":"166.6"},{"v":253.4553176266888,"d":"253.46"}]
["8. Цех наладки и автоматики"]
["Силовая нагрузка ",35,{"v":4,"d":"4.0"},{"v":25,"d":"25.0"},{"v":420,"d":"420.0"},{"v":0.3,"d":"0.30"},{"v":0.7,"d":"0.70"},{"v":1.020204061220407,"d":"1.02"},{"v":126,"d":"126.0"},{"v":128.54571171377128,"d":"128.5"},{"v":33.6,"d":"34"},0.75,94.5,{"v":128.54571171377128,"d":"128.5"}]
["Электрич. освещ.",{"$nulls":3},{"v":50.51904000000001,"d":"50.5"},{"$nulls":3},{"v":71.98963200000001,"d":"72.0"},{"v":34.86617009674243,"d":"34.9"},null,null,{"v":71.98963200000001,"d":"72.0"},{"v":34.86617009674243,"d":"34.9"}]
["Итого цех наладки и автоматики",35,{"v":4,"d":"4.0"},{"v":25,"d":"25.0"},{"v":470.51904,"d":"470.5"},{"v":0.4207898409382116,"d":"0.42"},{"v":0.7712385758784491,"d":"0.77"},{"v":0.8253557530250558,"d":"0.83"},{"v":197.98963200000003,"d":"198.0"},{"v":163.4118818105137,"d":"163.4"},{"v":33.6,"d":"34"},0.75,{"v":166.48963200000003,"d":"166.5"},{"v":163.4118818105137,"d":"163.4"},{"v":233.28574898683533,"d":"233.3"},{"v":354.8611940779363,"d":"354.86"}]
["9.Термический цех           \n"]
["Силовая нагрузка ",180,{"v":7,"d":"7.0"},{"v":75,"d":"75.0"},{"v":2400,"d":"2400.0"},{"v":0.7,"d":"0.70"},{"v":0.6,"d":"0.60"},{"v":1.3333333333333333,"d":"1.33"},{"v":1680,"d":"1680.0"},{"v":2240,"d":"2240.0"},64,{"v":0.8,"d":"0.80"},{"v":1344,"d":"1344.0"},{"v":2240,"d":"2240.0"}]
["Электрич. освещ.",{"$nulls":3},{"v":42.746880000000004,"d":"42.7"},{"$nulls":3},{"v":73.09716480000002,"d":"73.1"},{"v":35.40257271361539,"d":"35.4"},null,null,{"v":73.09716480000002,"d":"73.1"},{"v":35.40257271361539,"d":"35.4"}]
["Итого термический цех",180,{"v":7,"d":"7.0"},{"v":75,"d":"75.0"},{"v":2442.74688,"d":"2442.7"},{"v":0.7176745078065558,"d":"0.72"},{"v":0.6103202578627734,"d":"0.61"},{"v":1.2979329488409743,"d":"1.30"},{"v":1753.0971648,"d":"1753.1"},{"v":2275.4025727136154,"d":"2275.4"},64,{"v":0.8,"d":"0.80"},{"v":1417.0971648,"d":"1417.1"},{"v":2275.4025727136154,"d":"2275.4"},{"v":2680.600910690724,"d":"2680.6"},{"v":4077.579724202501,"d":"4077.58"}]
["10. Сварочный цех"]
["Силовая нагрузка ",84,{"v":4,"d":"4.0"},{"v":60,"d":"60.0"},{"v":940,"d":"940.0"},0.55,{"v":0.6,"d":"0.60"},{"v":1.3333333333333333,"d":"1.33"},{"v":517,"d":"517.0"},{"v":689.3333333333333,"d":"689.3"},{"v":31.333333333333332,"d":"31"},0.77,{"v":398.09000000000003,"d":"398.1"},{"v":689.3333333333333,"d":"689.3"}]
["Электрич. освещ.",{"$nulls":3},{"v":84.68064,"d":"84.7"},{"$nulls":3},{"v":129.5613792,"d":"129.6"},{"v":62.74943987983917,"d":"62.7"},null,null,{"v":129.5613792,"d":"129.6"},{"v":62.74943987983917,"d":"62.7"}]
["Итого сварочный цех",84,{"v":4,"d":"4.0"},{"v":60,"d":"60.0"},{"v":1024.68064,"d":"1024.7"},{"v":0.6309881869145103,"d":"0.63"},{"v":0.6519060641171709,"d":"0.65"},{"v":1.1632039855887086,"d":"1.16"},{"v":646.5613792,"d":"646.6"},{"v":752.0827732131725,"d":"752.1"},{"v":31.333333333333332,"d":"31"},0.77,{"v":527.6513792000001,"d":"527.7"},{"v":752.0827732131725,"d":"752.1"},{"v":918.718931847863,"d":"918.7"},{"v":1397.503699190543,"d":"1397.50"}]
["11. Административно-бытовой корпус"]
["Силовая нагрузка ",47,1.5,{"v":24,"d":"24.0"},{"v":380,"d":"380.0"},0.45,{"v":0.7,"d":"0.70"},{"v":1.020204061220407,"d":"1.02"},{"v":171,"d":"171.0"},{"v":174.45489446868962,"d":"174.5"},{"v":31.666666666666668,"d":"32"},0.77,{"v":131.67000000000002,"d":"131.7"},{"v":174.45489446868962,"d":"174.5"}]
["Электрич. освещ.",{"$nulls":3},{"v":13.685760000000002,"d":"13.7"},{"$nulls":3},{"v":10.6748928,"d":"10.7"},{"v":5.170086549814437,"d":"5.2"},null,null,{"v":10.6748928,"d":"10.7"},{"v":5.170086549814437,"d":"5.2"}]
["Итого административно-бытовой корпус",47,2.2,{"v":24,"d":"24.0"},{"v":393.68576,"d":"393.7"},{"v":0.46147184190761686,"d":"0.46"},{"v":0.7111072565633269,"d":"0.71"},{"v":0.9887165928659574,"d":"0.99"},{"v":181.6748928,"d":"181.7"},{"v":179.62498101850406,"d":"179.6"},{"v":31.666666666666668,"d":"32"},0.77,{"v":142.34489280000003,"d":"142.3"},{"v":179.62498101850406,"d":"179.6"},{"v":229.1881373722066,"d":"229.2"},{"v":348.62813716490206,"d":"348.63"}]
["12. Цех металлоизделий"]
["Силовая нагрузка ",42,2.5,{"v":60,"d":"60.0"},555.2,0.44,0.73,{"v":0.9362289657447548,"d":"0.94"},246.43,229.3,19,0.85,{"v":209.4655,"d":"209.5"},{"v":229.29843072077006,"d":"229.3"}]
["Электрич. освещ.",{"$nulls":3},{"v":16.1568,"d":"16.2"},{"$nulls":3},{"v":30.69792,"d":"30.7"},{"v":14.86768122854401,"d":"14.9"},null,null,{"v":30.69792,"d":"30.7"},{"v":14.86768122854401,"d":"14.9"}]
["Итого цех металлоизделий",42,2.2,{"v":60,"d":"60.0"},{"v":571.3568,"d":"571.4"},{"v":0.4850347803684143,"d":"0.49"},{"v":0.7503171202261043,"d":"0.75"},{"v":0.8810648931675451,"d":"0.88"},{"v":277.12792,"d":"277.1"},{"v":244.167681228544,"d":"244.2"},19,0.85,{"v":240.16342,"d":"240.2"},{"v":244.16611194931406,"d":"244.2"},{"v":342.48439165973883,"d":"342.5"},{"v":520.9680432913582,"d":"520.97"}]
["Освещение территории",{"$nulls":3},{"v":400.40000000000003,"d":"400.4"},{"$nulls":3},{"v":240.24,"d":"240.2"},{"v":116.3535424662457,"d":"116.4"},null,null,{"v":240.24,"d":"240.2"},{"v":116.3535424662457,"d":"116.4"}]
["ИТОГО НА 0,4 кВ ",null,0.8,{"v":75,"d":"75.0"},{"v":16069.35904,"d":"16069.4"},{"v":0.5304806473226951,"d":"0.53"},null,null,{"v":8524.483985600002,"d":"8524.5"},{"v":8142.750856567674,"d":"8142.8"},null,null,{"v":6781.564485599999,"d":"6781.6"},{"v":8142.749287288444,"d":"8142.7"},{"v":10596.885524907195,"d":"10596.9"},{"v":16119.387777467593,"d":"16119.39"}]

{"sheet":"Защ.аппар до 1кВ","index":3,"n_rows":38,"n_cols":18,"rows_kept":38,"merged":[[0,0,0,2],[1,0,1,10],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[17,1,17,2],[17,8,17,10],[17,12,17,13],[17,17,17,18],[18,1,18,2],[18,8,18,10],[18,12,18,13],[18,17,18,18],[19,1,19,2],[19,8,19,10],[19,12,19,13],[19,17,19,18],[20,1,20,2],[20,8,20,10],[20,12,20,13],[20,17,20,18],[21,1,21,2],[21,8,21,10],[21,12,21,13],[21,17,21,18],[22,1,22,2],[22,8,22,10],[22,12,22,13],[22,17,22,18],[23,1,23,2],[23,8,23,10],[23,12,23,13],[23,17,23,18],[24,1,24,2],[24,8,24,10],[24,12,24,13],[24,17,24,18],[25,1,25,2],[25,8,25,10],[25,12,25,13],[25,17,25,18],[26,1,26,2],[26,8,26,10],[26,12,26,13],[26,17,26,18],[27,1,27,2],[27,8,27,10],[27,12,27,13],[27,17,27,18],[28,1,28,2],[28,8,28,10],[28,12,28,13],[28,17,28,18],[29,1,29,2],[29,8,29,10],[29,12,29,13],[29,17,29,18],[30,1,30,2],[30,8,30,10],[30,12,30,13],[30,17,30,18],[32,13,32,15],[33,13,33,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[37,13,37,15]],"flags":["formulas_cached_only"]}
["Таблица 3.4"]
["            Выбор предохранителей на 0,4кВ"]
["№","Наименование",null,"Рн кВт","Кп","КПД","cosφ","α","Iн А","Iпуск А","Iпл.в, Iн","Iпл.в,Iп","Марка","Iпл.в А"]
[1,"Краны мостовые",null,25,6,81,0.9,1.6,{"v":52.16542867671331,"d":"52.2"},{"v":312.9925720602799,"d":"313.0"},{"v":57.38197154438465,"d":"57.4"},{"v":195.62035753767492,"d":"195.6"},"ПН2-250",200]
[2,"Продольно-строгал. станки",null,12.2,6,88.5,0.88,1.6,{"v":23.82891060939665,"d":"23.8"},{"v":142.97346365637992,"d":"143.0"},{"v":26.211801670336317,"d":"26.2"},{"v":89.35841478523744,"d":"89.4"},"ПН2-250",100]
[3,"Плоско-шлифовал. станки",null,3,5.5,82,0.83,2,{"v":6.705012783777374,"d":"6.7"},{"v":36.87757031077555,"d":"36.9"},{"v":7.375514062155111,"d":"7.4"},{"v":18.438785155387777,"d":"18.4"},"НПН2-63",20]
[4,"Токарно-револьвер. станки",null,3.5,5.5,84,0.84,2,{"v":7.545356647881747,"d":"7.5"},{"v":41.49946156334961,"d":"41.5"},{"v":8.299892312669924,"d":"8.3"},{"v":20.749730781674806,"d":"20.7"},"НПН2-63",25]
[5,"Токарные станки",null,15,6.5,88.5,0.88,1.6,{"v":29.297840913192605,"d":"29.3"},{"v":190.43596593575194,"d":"190.4"},{"v":32.22762500451187,"d":"32.2"},{"v":119.02247870984496,"d":"119"},"ПН2-250",125]
[6,"Вертикально-сверлил. станки",null,2.5,5,82,0.83,2,{"v":5.587510653147811,"d":"5.6"},{"v":27.937553265739055,"d":"27.9"},{"v":6.146261718462593,"d":"6.1"},{"v":13.968776632869528,"d":"14"},"НПН2-60",16]
[7,"Расточный станок",null,13,6,88.5,0.88,1.6,{"v":25.391462124766925,"d":"25.4"},{"v":152.34877274860156,"d":"152.3"},{"v":27.93060833724362,"d":"27.9"},{"v":95.21798296787597,"d":"95.2"},"ПН2-250",100]
[8,"Фрезерные станки",null,3.8,5.5,84,0.84,2,{"v":8.192101503414468,"d":"8.2"},{"v":45.056558268779575,"d":"45.1"},{"v":9.011311653755916,"d":"9.0"},{"v":22.528279134389788,"d":"22.5"},"НПН2-63",25]
[9,"Радиально-сверлил. станки",null,9.5,6,87.5,0.87,1.6,{"v":18.983076587222495,"d":"19.0"},{"v":113.89845952333496,"d":"113.9"},{"v":20.881384245944748,"d":"20.9"},{"v":71.18653720208435,"d":"71.2"},"ПН2-100",80]
[10,"Электрич. печь сопротив.",null,60,4,75,0.85,2,{"v":143.16648472592567,"d":"143.2"},{"v":572.6659389037027,"d":"572.7"},{"v":157.48313319851826,"d":"157.5"},{"v":286.33296945185134,"d":"286.3"},"ПН2-400",315]
[11,"Электрич. печи индукцион.",null,24,3,90,0.95,2,{"v":42.69877614632871,"d":"42.7"},{"v":128.09632843898612,"d":"128.1"},{"v":46.96865376096159,"d":"47.0"},{"v":64.04816421949306,"d":"64"},"ПН2-100",80]
[12,"Электродуговые печи",null,50,4,90,0.8,2,{"v":105.63499307034444,"d":"105.6"},{"v":422.53997228137774,"d":"422.5"},{"v":116.19849237737888,"d":"116.2"},{"v":211.26998614068887,"d":"211.3"},"ПН2-250",250]
[13,"Вентиляторы",null,5,5.5,87.5,0.91,2.5,{"v":9.551924020175575,"d":"9.6"},{"v":52.53558211096566,"d":"52.5"},{"v":10.507116422193134,"d":"10.5"},{"v":21.014232844386264,"d":"21"},"НПН2-63",25]
[]
["№","Наименование",null,"Iдоп. (Iн) ","Kз","Kt","Kп","Iдоп (Iз)  ","Марка и сечение проводника",null,null,"Iдоп, А  ","Тип магн. пуск",null,"Iн,А",null,null,"Тип магн. пуск"]
[1,"Краны мостовые",null,{"v":57.38197154438465,"d":"57.4"},1,1,1,200,"2АПВ-(3х50+1х35)",null,null,120,"ПМА-12-063",null,63,null,null,"ПМА-410004"]
[2,"Продольно-строгал. станки",null,{"v":26.211801670336317,"d":"26.2"},1,1,1,100,"АПВ-(3х50+1х35)",null,null,120,"ПМА-12-063",null,63,null,null,"ПМА-410004"]
[3,"Плоско-шлифовал. станки",null,{"v":7.375514062155111,"d":"7.4"},0.33,1,1,{"v":6.6000000000000005,"d":"6.6"},"АПВ-(3х2,5+1х2,5)",null,null,19,"ПМА-12-025",null,25,null,null,"ПМА-210004"]
[4,"Токарно-револьвер. станки",null,{"v":8.299892312669924,"d":"8.3"},0.33,1,1,{"v":8.25,"d":"8.3"},"АПВ-(3х2,5+1х2,5)",null,null,19,"ПМА-12-063",null,63,null,null,"ПМА-410004"]
[5,"Токарные станки",null,{"v":32.22762500451187,"d":"32.2"},1,1,1,125,"АПВ-(3х70+1х50)",null,null,140,"ПМА-12-025",null,25,null,null,"ПМА-210004"]
[6,"Вертикально-сверлил. станки",null,{"v":6.146261718462593,"d":"6.1"},0.33,1,1,{"v":5.28,"d":"5.3"},"АПВ-(3х2,5+1х2,5)",null,null,19,"ПМА-12-10",null,10,null,null,"ПМА-110004"]
[7,"Расточный станок",null,{"v":27.93060833724362,"d":"27.9"},1,1,1,100,"2АПВ-(3х50+1х35)",null,null,120,"ПМА-12-10",null,10,null,null,"ПМА-110004"]
[8,"Фрезерные станки",null,{"v":9.011311653755916,"d":"9.0"},0.33,1,1,{"v":8.25,"d":"8.3"},"АПВ-(3х2,5+1х2,5)",null,null,19,"ПМА-12-40",null,40,null,null,"ПМА-310004"]
[9,"Радиально-сверлил. станки",null,{"v":20.881384245944748,"d":"20.9"},1,1,1,80,"АПВ-(3х35+1х25)",null,null,85,"ПМА-12-40",null,40,null,null,"ПМА-310004"]
[10,"Электрич. печь сопротив.",null,{"v":157.48313319851826,"d":"157.5"},1.25,0.87,0.78,{"v":580.238726790451,"d":"580.2"},"3АВВГ-(3х120+1х95)",null,null,200,"ПМА-12-025",null,25,null,null,"ПМА-210004"]
[11,"Электрич. печи индукцион.",null,{"v":46.96865376096159,"d":"47.0"},1.25,0.87,1,{"v":114.94252873563218,"d":"114.9"},"АПВ-(3х70+1х50)",null,null,140,"ПМА-12-025",null,25,null,null,"ПМА-210004"]
[12,"Электродуговые печи",null,{"v":116.19849237737888,"d":"116.2"},1.25,0.87,0.78,{"v":460.5069260241674,"d":"460.5"},"2АВВГ-(3х150+1х120)",null,null,120,"ПМА-12-025",null,25,null,null,"ПМА-210004"]
[13,"Вентиляторы",null,{"v":10.507116422193134,"d":"10.5"},0.33,1,1,{"v":8.25,"d":"8.3"},"АПВ-(3х2,5+1х2,5)",null,null,19,"ПМА-12-063",null,63,null,null,"ПМА-410004"]
[]
["№","Наименование","Мощ.прием.","Iр, А","Iн, A","Iп, А","Ки","Iпик, А","α","Iпл.в (Iр)","Iпл.в (Iп) А","Iпл.в А  ","Тип","Кабель",null,null,"Iдоп, А  "]
[1,"ШРА-1","Кран мост.",125.4,52.2,313,0.3,{"v":422.73999999999995,"d":"422.7"},1.6,{"v":137.94000000000003,"d":"137.9"},{"v":264.2125,"d":"264.2"},315,"ПН2-400","АВВГ-(3х185+1х160)",null,null,260]
[2,"ШРА-2","Расточ. стан.",57.4,25.4,50.8,0.2,{"v":103.11999999999999,"d":"103.1"},2,{"v":63.14,"d":"63.1"},{"v":51.559999999999995,"d":"51.6"},80,"ПН2-100","АВВГ-(3х25+1х16)",null,null,75]
[3,"ШРА-3","Ток.рев.стан.",18.2,7.5,22.5,0.2,39.2,2,{"v":20.02,"d":"20"},19.6,25,"НПН2-63","АВВГ-(3х10+1х6)",null,null,45]
[4,"ШР-1","Кран мост.",88.8,52.2,313,0.3,{"v":386.14,"d":"386.1"},1.6,{"v":97.68,"d":"97.7"},{"v":241.33749999999998,"d":"241"},250,"ПН2-250","АВВГ-(3х185+1х160)",null,null,260]
[5,"ШР-2","Кран мост.",59.1,52.2,313,0.3,{"v":356.44,"d":"356.4"},1.6,{"v":65.01,"d":"65"},{"v":222.77499999999998,"d":"222.8"},250,"ПН2-250","АВВГ-(3х150+1х120)",null,null,240]

{"sheet":"Ф202-90-0,4","index":4,"n_rows":58,"n_cols":16,"rows_kept":58,"merged":[[1,0,1,5],[2,0,4,0],[2,1,4,1],[2,2,2,4],[2,5,4,5],[2,6,4,6],[2,6,4,6],[5,0,5,6],[23,8,23,11],[24,10,24,11],[24,14,24,15],[25,10,25,11],[25,14,25,15],[26,10,26,11],[26,14,26,15],[27,10,27,11],[27,14,27,15],[28,10,28,11],[28,14,28,15],[29,10,29,11],[29,14,29,15],[30,10,30,11],[30,14,30,15],[31,10,31,11],[31,14,31,15],[32,10,32,11],[32,14,32,15]],"flags":["formulas_cached_only"]}
["Таблица 4.4"]
["         Результирующие электрические нагрузки цеховых трансформаторных подстанций"]
["Наименование","Коэф. реактивной мощности cos f","Расчетная нагрузка",null,null,"Коээфиц загрузки тр-ров","Расчетный послеавр ток IР.А"]
[null,null,"кВт","кВАр","кВА"]
[null,null,"Рр","Qp","Sp"]
["ТП-1, 2х1000"]
["3. Цех сборки эл. машин",null,{"v":806.2805599999998,"d":"806.28"},{"v":784.6240689313917,"d":"784.6"},{"$nulls":4},"β","К1","К2","Рр","g, гамма  ","S тр-ра ","Nэк","Кз"]
["40 % освещения территории",null,{"v":96.096,"d":"96.1"},{"v":46.541416986498284,"d":"46.5"},{"$nulls":4},0.55,11,2,{"v":6781.564485599999,"d":"6781.56"},0.06,{"v":1000,"d":"1000.00"},14,{"v":0.4843974632571428,"d":"0.48"}]
["Итого без компенсации 0,4 кВ",{"v":0.7355332524744422,"d":"0.74"},{"v":902.3765599999998,"d":"902.38"},{"v":831.1654859178899,"d":"831.2"},{"v":1226.8331268019117,"d":"1226.8"},{"$nulls":3},"Qт",{"v":3646.9690329983387,"d":"3646.97"},"Qнк1",{"v":4495.780254290105,"d":"4495.78"},"Nмин","n","Nmin","m"]
["Компенсация",null,null,-775,{"$nulls":4},"Qp",{"v":8142.749287288444,"d":"8142.75"},"Qнк2",{"v":2806.9690329983387,"d":"2806.97"},{"v":12.330117246545452,"d":"12.33"},{"v":0.669882753454548,"d":"0.67"},13,1]
["Итого с компенсацией",{"v":0.9980685929356882,"d":"1.00"},{"v":902.3765599999998,"d":"902.38"},{"v":56.165485917889896,"d":"56.2"},{"v":904.1227891419538,"d":"904.1"},{"v":0.45206139457097694,"d":"0.45"},null,null,"Qpтп",{"v":891.92196460166,"d":"891.92"},"Qнк",{"v":7302.749287288444,"d":"7302.75"},"Qку",{"v":799.9119537525006,"d":"799.91"}]
["Потери в тр-рах",null,{"v":10.577652899936625,"d":"10.58"},{"v":76.56673557998934,"d":"76.6"}]
["Итого 6 кВ ТП-1",{"v":0.989595873784285,"d":"0.99"},{"v":912.9542128999365,"d":"912.95"},{"v":132.73222149787924,"d":"132.7"},{"v":922.5525662397263,"d":"922.6"},{"v":0.46127628311986313,"d":"0.46"},{"v":88.87789655488693,"d":"88.88"},null,"Подстанция","Pp","Qр","Sр","Qку","Sр с комп","cosϕ"]
["ТП-2, ТП-3, 4х1000",{"$nulls":7},"ТП-1",{"v":902.3765599999998,"d":"902.38"},{"v":831.1654859178899,"d":"831.17"},{"v":1226.8331268019117,"d":"1226.8"},745.42,{"v":906.4412525876833,"d":"906.44"},{"v":0.9955157683125303,"d":"1.00"}]
["9. Термический цех",null,{"v":1417.0971648,"d":"1417.10"},{"v":2275.4025727136154,"d":"2275.4"},{"$nulls":4},"ТП-2,3",{"v":1944.748544,"d":"1944.75"},{"v":3027.485345926788,"d":"3027.49"},{"v":3598.2932647564407,"d":"3598.3"},2715.17,{"v":1969.666919733255,"d":"1969.67"},{"v":0.9873489393137447,"d":"0.99"}]
["10. Сварочный цех",null,{"v":527.6513792000001,"d":"527.65"},{"v":752.0827732131725,"d":"752.1"},{"$nulls":4},"ТП-4",{"v":988.0937472,"d":"988.09"},{"v":991.8045211920204,"d":"991.80"},{"v":1400.0019505388807,"d":"1400.0"},889.49,{"v":993.3768240212221,"d":"993.38"},{"v":0.9946816991362493,"d":"0.99"}]
["Итого без компенсации 0,4 кВ",{"v":0.5404641592301219,"d":"0.54"},{"v":1944.748544,"d":"1944.75"},{"v":3027.485345926788,"d":"3027.5"},{"v":3598.2932647564407,"d":"3598.3"},{"$nulls":3},"ТП-5",{"v":1033.6439520000001,"d":"1033.64"},{"v":1155.685564259002,"d":"1155.69"},{"v":1550.4931289569863,"d":"1550.5"},1036.47,{"v":1040.4961173727515,"d":"1040.50"},{"v":0.9934145209594313,"d":"0.99"}]
["Компенсация",null,null,-2800,{"$nulls":4},"ТП-6",{"v":1016.9796616,"d":"1016.98"},{"v":1244.6864053910836,"d":"1244.69"},{"v":1607.3244476064647,"d":"1607.3"},1116.29,{"v":1025.0528127981513,"d":"1025.05"},{"v":0.9921241607287399,"d":"0.99"}]
["Итого с компенс.",{"v":0.993227939479434,"d":"0.99"},{"v":1944.748544,"d":"1944.75"},{"v":227.4853459267879,"d":"227.5"},{"v":1958.0082946712841,"d":"1958.0"},{"v":0.48950207366782106,"d":"0.49"},null,null,"ТП-7",{"v":895.7220208000001,"d":"895.72"},{"v":891.92196460166,"d":"891.92"},{"v":1264.0580403940796,"d":"1264.1"},799.91,{"v":900.4355280506722,"d":"900.44"},{"v":0.9947653028963925,"d":"0.99"}]
["Потери в тр-рах",null,{"v":22.734630149604342,"d":"22.73"},{"v":162.2991928325252,"d":"162.3"}]
["Итого 6 кВ ТП-2, ТП-3",{"v":0.980934974884341,"d":"0.98"},{"v":1967.4831741496043,"d":"1967.48"},{"v":389.7845387593131,"d":"389.8"},{"v":2005.7223205662374,"d":"2005.7"},{"v":0.5014305801415594,"d":"0.50"},{"v":193.22951065185333,"d":"193.23"}]
["ТП-4, 2х1000"]
["6. Литейный цех",null,{"v":940.0457472,"d":"940.05"},{"v":968.5338126987713,"d":"968.5"}]
["20 % освещения территории",null,{"v":48.048,"d":"48.0"},{"v":23.270708493249142,"d":"23.3"},{"$nulls":4},"Таблица 4.1 Компенсирующие устройства по ТП"]
["Итого без компенс 0,4 кВ",{"v":0.7057802646772519,"d":"0.71"},{"v":988.0937472,"d":"988.09"},{"v":991.8045211920204,"d":"991.8"},{"v":1400.0019505388807,"d":"1400.0"},{"$nulls":3},"Номер ТП","Qр","Тип и кол-во КУ",null,"Qку.ном","Qку","Примечание"]
["Компенсация",null,null,-900,{"$nulls":4},"ТП-1",{"v":831.1654859178899,"d":"831.17"},"2хУКМ63-0,38-450-У3",null,775,{"v":745.42,"d":"745.4"},"Снят предохранитель"]
["Итого с компенсацией",{"v":0.9957115420946959,"d":"1.00"},{"v":988.0937472,"d":"988.09"},{"v":91.80452119202039,"d":"91.8"},{"v":992.3493958112907,"d":"992.3"},{"v":0.49617469790564533,"d":"0.50"},null,null,"ТП-2",{"v":1513.742672963394,"d":"1513.74"},"2хУКМ63-0,38-700-У3",null,1400,{"v":1357.585,"d":"1357.6"}]
["Потери в тр-рах",null,{"v":11.514641010855389,"d":"11.51"},{"v":82.0046130094286,"d":"82.0"},{"$nulls":4},"ТП-3",{"v":1513.742672963394,"d":"1513.74"},"2хУКМ63-0,38-700-У3",null,1400,{"v":1357.585,"d":"1357.6"}]
["Итого 6 кВ ТП-4",{"v":0.9852177110046998,"d":"0.99"},{"v":999.6083882108554,"d":"999.61"},{"v":173.80913420144898,"d":"173.8"},{"v":1014.6065961314077,"d":"1014.6"},{"v":0.5073032980657038,"d":"0.51"},{"v":97.74630020533795,"d":"97.75"},null,"ТП-4",{"v":991.8045211920204,"d":"991.80"},"2хУКМ63-0,38-450-У3",null,900,{"v":889.49,"d":"889.5"}]
["ТП-5, 2х1000",{"$nulls":7},"ТП-5",{"v":1155.685564259002,"d":"1155.69"},"2хУКМ63-0,38-550-У3",null,1100,{"v":1036.47,"d":"1036.5"}]
["5. Кузнечный цех",null,{"v":1033.6439520000001,"d":"1033.64"},{"v":1155.685564259002,"d":"1155.7"},{"$nulls":4},"ТП-6",{"v":1244.6864053910836,"d":"1244.69"},"2хУКМ63-0,38-600-У3",null,1200,{"v":1116.29,"d":"1116.3"}]
["Итого без компенс 0,4 кВ",{"v":0.6666549710512617,"d":"0.67"},{"v":1033.6439520000001,"d":"1033.64"},{"v":1155.685564259002,"d":"1155.7"},{"v":1550.4931289569863,"d":"1550.5"},{"$nulls":3},"ТП-7",{"v":891.92196460166,"d":"891.92"},"2хУКМ63-0,38-400-У3",null,800,{"v":799.91,"d":"799.9"}]
["Компенсация",null,null,-1100,{"$nulls":5},{"v":8142.749287288444,"d":"8142.75"},"Сумма",null,7575,{"v":7302.75,"d":"7302.8"}]
["Итого с компенсацией",{"v":0.9985519977677725,"d":"1.00"},{"v":1033.6439520000001,"d":"1033.64"},{"v":55.68556425900192,"d":"55.7"},{"v":1035.1428411446518,"d":"1035.1"},{"v":0.5175714205723259,"d":"0.52"}]
["Потери в тр-орах",null,{"v":12.000515928808921,"d":"12.00"},{"v":84.8244228011232,"d":"84.8"}]
["Итого 6 кВ ТП-5",{"v":0.9908867364715263,"d":"0.99"},{"v":1033.6439520000001,"d":"1033.64"},{"v":140.50998706012513,"d":"140.5"},{"v":1043.1504570146221,"d":"1043.2"},{"v":0.5215752285073111,"d":"0.52"},{"v":100.49619046383644,"d":"100.50"}]
["ТП-6, 2х1000"]
["1. Сборочный цех",null,{"v":606.918816,"d":"606.92"},{"v":784.3927816712328,"d":"784.4"}]
["2. Склады ",null,{"v":169.8974256,"d":"169.90"},{"v":216.12751177053673,"d":"216.1"}]
["12. Цех металлоизделий  ",null,{"v":240.16342,"d":"240.16"},{"v":244.16611194931406,"d":"244.2"}]
["Итого без компенсации 0,4 кВ",{"v":0.6327158546704292,"d":"0.63"},{"v":1016.9796616,"d":"1016.98"},{"v":1244.6864053910836,"d":"1244.7"},{"v":1607.3244476064647,"d":"1607.3"}]
["Компенсация",null,null,-1200]
["Итого с компенсацией",{"v":0.9990360200941302,"d":"1.00"},{"v":1016.9796616,"d":"1016.98"},{"v":44.686405391083554,"d":"44.7"},{"v":1017.9609555060679,"d":"1018.0"},{"v":0.5089804777530339,"d":"0.51"},{"v":1548.4650981230118,"d":"1548.47"}]
["Потери в тр-рах",null,{"v":11.80296923883503,"d":"11.80"},{"v":83.67794647538186,"d":"83.7"}]
["Итого 6 кВ ТП-6",{"v":0.992305568702988,"d":"0.99"},{"v":1028.782630838835,"d":"1028.78"},{"v":128.36435186646543,"d":"128.4"},{"v":1036.7599087280394,"d":"1036.8"},{"v":0.5183799543640197,"d":"0.52"},{"v":99.88053070597682,"d":"99.88"}]
["ТП-7, 2х1000"]
["8. Цех наладки и автоматики",null,{"v":166.48963200000003,"d":"166.49"},{"v":163.4118818105137,"d":"163.4"}]
["11. Админ. бытовой корпус",null,{"v":142.34489280000003,"d":"142.34"},{"v":179.62498101850406,"d":"179.6"}]
["7. Компрессорная  ",null,{"v":154.78228000000001,"d":"154.78"},{"v":61.68613021187201,"d":"61.7"}]
["4. Цех механич. оборудов.",null,{"v":336.009216,"d":"336.01"},{"v":440.657554574272,"d":"440.7"}]
["40 % освещения территории",null,96.096,{"v":46.541416986498284,"d":"46.5"}]
["Итого без компенсации 0,4 кВ",{"v":0.7086083013409353,"d":"0.71"},{"v":895.7220208000001,"d":"895.72"},{"v":891.92196460166,"d":"891.9"},{"v":1264.0580403940796,"d":"1264.1"}]
["Компенсация",null,null,-800]
["Итого с компенсацией",{"v":0.9947754582814854,"d":"0.99"},{"v":895.7220208000001,"d":"895.72"},{"v":91.92196460165997,"d":"91.9"},{"v":900.4263357556046,"d":"900.4"},{"v":0.4502131678778023,"d":"0.45"}]
["Потери в тр-рах",null,{"v":10.540298482284683,"d":"10.54"},{"v":76.3499465489736,"d":"76.3"}]
["Итого 6 кВ ТП-7",{"v":0.9831953472521204,"d":"0.98"},{"v":906.2623192822848,"d":"906.26"},{"v":168.27191115063357,"d":"168.3"},{"v":921.75204227232,"d":"921.8"},{"v":0.46087602113616,"d":"0.46"},{"v":88.80077478538729,"d":"88.80"}]
["Итого 0,4 кВ с компенс",{"v":0.996513836544846,"d":"1.00"},{"v":6781.5644856,"d":"6781.56"},{"v":567.7492872884436,"d":"567.7"},{"v":6805.288834837778,"d":"6805.3"}]
["Итого по всем ТП компенс.",null,null,-7575]

{"sheet":"Потери цех тр-ров","index":5,"n_rows":12,"n_cols":15,"rows_kept":12,"merged":[[2,0,2,7],[3,0,5,0],[3,1,5,1],[3,2,3,5],[3,6,4,7],[3,9,3,14],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,9,4,14],[5,9,6,9],[14,0,14,3],[15,0,15,3],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4]],"flags":["formulas_cached_only"]}
[]
["Таблица 4.1"]
["Потери мощности цеховых трансформаторов"]
["№ подстанции ","Кол-во тр-ров","Расчетные мощности",{"$nulls":3},"Потери расчетные",null,null,"Таблица 4.2"]
[null,null,"Рр, кВт","Qр, кВт","Sр кВА","kз.р",{"$nulls":3},"Технические данные трансформатора 10/0,4 кВ"]
[{"$nulls":6},"Рр, кВт","Qр, квар",null,"Тип тр-тора","Sном","Uк","Ркз","Рхх","I хx"]
["ТП-1",2,{"v":902.3765599999998,"d":"902.38"},{"v":56.165485917889896,"d":"56.17"},{"v":904.1227891419538,"d":"904.12"},{"v":0.45206139457097694,"d":"0.45"},{"v":10.577652899936625,"d":"10.58"},{"v":76.56673557998934,"d":"76.57"},null,null,"КВА","%","кВт","кВт","%"]
["ТП-2, ТП-3",4,{"v":1944.748544,"d":"1944.75"},{"v":227.4853459267879,"d":"227.49"},{"v":1958.0082946712841,"d":"1958.01"},{"v":0.48950207366782106,"d":"0.49"},{"v":22.734630149604342,"d":"22.73"},{"v":162.2991928325252,"d":"162.30"},null,"ТСЗ-1000/6",1000,6.5,11.2,3,2.5]
["ТП-4",2,{"v":988.0937472,"d":"988.09"},{"v":91.80452119202039,"d":"91.80"},{"v":992.3493958112907,"d":"992.35"},{"v":0.49617469790564533,"d":"0.50"},{"v":11.514641010855389,"d":"11.51"},{"v":82.0046130094286,"d":"82.00"}]
["ТП-5",2,{"v":1033.6439520000001,"d":"1033.64"},{"v":55.68556425900192,"d":"55.69"},{"v":1035.1428411446518,"d":"1035.14"},{"v":0.5175714205723259,"d":"0.52"},{"v":12.000515928808921,"d":"12.00"},{"v":84.8244228011232,"d":"84.82"},null,"Qxx","Qкз"]
["ТП-6",2,{"v":1016.9796616,"d":"1016.98"},{"v":44.686405391083554,"d":"44.69"},{"v":1017.9609555060679,"d":"1017.96"},{"v":0.5089804777530339,"d":"0.51"},{"v":11.80296923883503,"d":"11.80"},{"v":83.67794647538186,"d":"83.68"},null,25,65]
["ТП-7",2,{"v":895.7220208000001,"d":"895.72"},{"v":91.92196460165997,"d":"91.92"},{"v":900.4263357556046,"d":"900.43"},{"v":0.4502131678778023,"d":"0.45"},{"v":10.540298482284683,"d":"10.54"},{"v":76.3499465489736,"d":"76.35"}]

{"sheet":"6 кВ","index":6,"n_rows":12,"n_cols":15,"rows_kept":12,"merged":[[0,0,0,13],[1,0,1,13],[2,0,2,6],[2,7,2,8],[2,9,5,9],[2,10,5,10],[2,11,2,13],[2,14,4,14],[3,0,3,3],[3,4,3,6],[3,7,4,7],[3,8,4,8],[3,11,4,11],[3,12,4,12],[3,13,4,13],[4,0,5,0],[4,1,5,1],[4,2,4,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[7,0,7,13],[9,0,9,13]],"flags":["formulas_cached_only"]}
["Таблица 4.3"]
["           Электрические нагрузки 6 кВ"]
["Исходные данные",{"$nulls":6},"Расчетные величины",null,"Эффективн. число эл.приемн.   nэ","Коэф. расчетной нагрузки Кр","Расчетная мощность",null,null,"Расчетный ток"]
["По заданию технологов",{"$nulls":3},"По справочным данным",null,null,"Активная мощность  ","Реактивная, мощность",null,null,"Активная Р мах","Реактивная Qмах","Полная Sмах"]
["Наименование ЭП","Кол-воЭП, шт n"," Установленная (номинальная) мощность, кВт",null,"Коэффициент использов    Ки","соs","tq"]
[null,null,"одного ЭП, p","общая Р=n*p",{"$nulls":3},"  Рпр=Ки*р  кВт","Qпр=Рпр*tqf, кВАр",null,null,"кВт","кВАр","кВА","А"]
[2,3,4,5,{"v":7,"d":"7.00"},{"v":8,"d":"8.00"},{"v":9,"d":"9.00"},10,11,12,13,14,15,16]
["6. Литейный цех"]
["ДСП-6 кВ",4,2500,10000,0.6,0.8,{"v":0.7499999999999998,"d":"0.75"},6000,{"v":4499.999999999999,"d":"4500"},4,1,6000,{"v":4949.999999999999,"d":"4950.0"},{"v":7778.335297478503,"d":"7778.3"}]
["7. Компрессорная"]
["СДВ-6 кВ",4,1000,4000,0.8,-0.9,{"v":-0.4843221048378532,"d":"-0.48"},3200,{"v":-1549.8307354811302,"d":"-1550"},4,0.97,3104,{"v":-1704.8138090292434,"d":"-1704.8"},{"v":3541.3565371841337,"d":"3541.4"}]
["Итого по нагруз. 6 кВ",8,null,14000,{"$nulls":3},9200,{"v":2950.1692645188687,"d":"2950"},8,null,9104,{"v":3245.186190970756,"d":"3245.2"},{"v":11319.691834662637,"d":"11319.7"},1089.2378546476803]

{"sheet":"Ф202-90-6кВ","index":7,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[1,0,1,6],[2,0,4,0],[2,1,4,1],[2,2,2,4],[2,5,4,5],[2,6,4,6]],"flags":["formulas_cached_only"]}
["Таблица 4.4"]
["         Результирующие электрические нагрузки ГПП  110/6 кВ. Вариант 1 и 2"]
["Наименование узла","Коэф. реактивной мощности cos f","Расчетная нагрузка",null,null,"Количество и мощность трансформ. шт. кВА","Расчетный послеаварийн. ток А"]
[null,null,"кВт","кВАр","кВА"]
[null,null,"Рр","Qp","Sp"]
["Печи ДСП -2500 кВт",null,6000,{"v":4949.999999999999,"d":"4950.0"},{"v":7778.335297478503,"d":"7778.3"},"4х2500"]
["Двигатели СД -1000 кВт",null,{"v":3104,"d":"3104.0"},{"v":-1704.8138090292434,"d":"-1704.8"},{"v":3541.3565371841337,"d":"3541.4"},"4х1000"]
["Магист. ТП-1, ТП-2",{"v":0.9854071805199872,"d":"0.99"},{"v":1896.6957999747387,"d":"1896.7"},{"v":327.6244908775358,"d":"327.6"},{"v":1924.7838228394842,"d":"1924.8"},"4х1000",{"v":185.43196751825477,"d":"185.4"}]
["Магист. ТП-3, ТП-7",{"v":0.9840121806498798,"d":"0.98"},{"v":1890.003906357087,"d":"1890.0"},{"v":342.0810453520826,"d":"342.1"},{"v":1920.7119012580263,"d":"1920.7"},"4х1000",{"v":185.039682202122,"d":"185.0"}]
["ТП-4",{"v":0.9815188694144448,"d":"0.98"},{"v":999.6083882108554,"d":"999.6"},{"v":194.89226937965654,"d":"194.9"},{"v":1018.4301284061941,"d":"1018.4"},"2х1000",{"v":98.11465591581832,"d":"98.1"}]
["Магист. ТП-5, ТП-6",{"v":0.9916089077700476,"d":"0.99"},{"v":2062.426582838835,"d":"2062.4"},{"v":268.87433892659055,"d":"268.9"},{"v":2079.879039688002,"d":"2079.9"},"4х1000",{"v":200.37370324547229,"d":"200.4"}]
["ЗРУ-6 без компенсации",{"v":0.9643342292650164,"d":"0.96"},{"v":15952.734677381519,"d":"15952.7"},{"v":4378.658335506621,"d":"4378.7"},{"v":16542.74440671899,"d":"16542.7"},null,{"v":1593.713333980635,"d":"1593.7"}]
["Компенсация",null,null,{"v":-2200,"d":"-2200.0"}]
["Итого ЗРУ-6",{"v":0.9908028303109936,"d":"0.99"},{"v":15952.734677381519,"d":"15952.7"},{"v":2178.6583355066214,"d":"2178.7"},{"v":16100.81661996693,"d":"16100.8"},null,{"v":1551.1384026943094,"d":"1551.1"}]
["Потери в тр-рах ГПП",null,{"v":95.0372756748697,"d":"95.0"},{"v":1122.619095691542,"d":"1122.6"},null,"2х16000"]
["Итого на 110 кВ",{"v":0.9794892858688615,"d":"0.98"},{"v":16047.771953056388,"d":"16047.8"},{"v":3301.2774311981634,"d":"3301.3"},{"v":16383.815713533939,"d":"16383.8"},null,{"v":86.0946700658641,"d":"86.1"}]

{"sheet":"Картограмма","index":8,"n_rows":17,"n_cols":17,"rows_kept":17,"merged":[[0,0,0,14],[1,1,1,14]],"flags":["formulas_cached_only"]}
["Таблица 5.1"]
[null,"  Картограмма электрическиз нагрузок"]
["№","Наименование цехов","Рр, кВт","Qр, кВт","Sр, кВт","Ri,м - (Р) ","Х,м","Y,м","Рi*X","Pi*Y","Qi*X","Qi*Y","Ri,м - (Q) ","освещ Рро кВт","угол-доля освещ.",null,"                 \n"]
[1,"Сборочный цех",{"v":606.918816,"d":"606.92"},{"v":784.3927816712328,"d":"784.39"},{"v":991.7774373077742,"d":"991.78"},{"v":13.902742432115971,"d":"13.9"},424,160,{"v":257333.577984,"d":"257334"},{"v":97107.01056,"d":"97107"},{"v":332582.53942860273,"d":"332583"},{"v":125502.84506739725,"d":"125503"},{"v":15.805271853613737,"d":"15.8"},{"v":102.91881600000002,"d":"102.92"},{"v":61.04733085091896,"d":"61.0"}]
[2,"Склады  ",{"v":169.8974256,"d":"169.90"},{"v":216.12751177053673,"d":"216.13"},{"v":274.91132492065697,"d":"274.91"},{"v":7.355777347239759,"d":"7.4"},419,24,{"v":71187.02132639999,"d":"71187"},{"v":4077.5382143999996,"d":"4078"},{"v":90557.42743185489,"d":"90557"},{"v":5187.060282492881,"d":"5187"},{"v":8.296409932092159,"d":"8.3"},{"v":19.702425600000005,"d":"19.70"},{"v":41.74797346664447,"d":"41.7"}]
[3,"Цех сборки электрических маш.  ",{"v":806.2805599999998,"d":"806.28"},{"v":784.6240689313917,"d":"784.62"},{"v":1125.0436751434881,"d":"1125.04"},{"v":16.0242706045437,"d":"16.0"},47,261,{"v":37895.18631999999,"d":"37895"},{"v":210439.22615999996,"d":"210439"},{"v":36877.331239775405,"d":"36877"},{"v":204786.88199109322,"d":"204787"},{"v":15.807601865233782,"d":"15.8"},{"v":134.98056,"d":"134.98"},{"v":60.268105186611486,"d":"60.3"}]
[4,"Цех механического оборуд.",{"v":336.009216,"d":"336.01"},{"v":440.657554574272,"d":"440.66"},{"v":554.149143859586,"d":"554.15"},{"v":10.34453017099369,"d":"10.3"},25,179,{"v":8400.2304,"d":"8400"},{"v":60145.649664,"d":"60146"},{"v":11016.4388643568,"d":"11016"},{"v":78877.70226879469,"d":"78878"},{"v":11.846383448961621,"d":"11.8"},{"v":50.409216,"d":"50.41"},{"v":54.008392912651544,"d":"54.0"}]
[5,"Кузнечный цех",{"v":1033.6439520000001,"d":"1033.64"},{"v":1155.685564259002,"d":"1155.69"},{"v":1550.4931289569863,"d":"1550.49"},{"v":18.143482906391547,"d":"18.1"},376,262,{"v":388650.12595200003,"d":"388650"},{"v":270814.71542400005,"d":"270815"},{"v":434537.7721613847,"d":"434538"},{"v":302789.6178358585,"d":"302790"},{"v":19.184700348741956,"d":"19.2"},{"v":42.65395200000001,"d":"42.65"},{"v":14.855620922744974,"d":"14.9"}]
[6,"Литейный цех    ",{"v":6940.0457472,"d":"6940.05"},{"v":5918.53381269877,"d":"5918.53"},{"v":9121.034890037832,"d":"9121.03"},{"v":47.01282433522285,"d":"47.0"},273,246,{"v":1894632.4889856,"d":"1894632"},{"v":1707251.2538112,"d":"1707251"},{"v":1615759.7308667642,"d":"1615760"},{"v":1455959.3179238974,"d":"1455959"},{"v":43.415243634469824,"d":"43.4"},{"v":109.6457472,"d":"109.65"},{"v":5.687638155400545,"d":"5.7"}]
[7,"Компрессорная",{"v":3258.78228,"d":"3258.78"},{"v":1643.1276788173714,"d":"1643.13"},{"v":3649.5931988836455,"d":"3649.59"},{"v":32.21534962703892,"d":"32.2"},280,110,{"v":912459.0384,"d":"912459"},{"v":358466.05079999997,"d":"358466"},{"v":460075.75006886397,"d":"460076"},{"v":180744.04466991086,"d":"180744"},{"v":22.875512446436275,"d":"22.9"},{"v":18.782280000000004,"d":"18.78"},{"v":2.074891851934337,"d":"2.1"}]
[8,"Цех наладки и автоматики",{"v":166.48963200000003,"d":"166.49"},{"v":163.4118818105137,"d":"163.41"},{"v":233.28574898683533,"d":"233.29"},{"v":7.281632769934114,"d":"7.3"},174,46,{"v":28969.195968000004,"d":"28969"},{"v":7658.523072000002,"d":"7659"},{"v":28433.667435029383,"d":"28434"},{"v":7516.946563283631,"d":"7517"},{"v":7.214014179123626,"d":"7.2"},{"v":71.98963200000001,"d":"71.99"},{"v":155.66295155244262,"d":"155.7"}]
[9,"Термический цех ",{"v":1417.0971648,"d":"1417.10"},{"v":2275.4025727136154,"d":"2275.40"},{"v":2680.600910690724,"d":"2680.60"},{"v":21.243936300839827,"d":"21.2"},160,179,{"v":226735.54636799998,"d":"226736"},{"v":253660.39249919998,"d":"253660"},{"v":364064.4116341785,"d":"364064"},{"v":407297.06051573716,"d":"407297"},{"v":26.919333217303297,"d":"26.9"},{"v":73.09716480000002,"d":"73.10"},{"v":18.569636565262577,"d":"18.6"}]
[10,"Сварочный цех",{"v":527.6513792000001,"d":"527.65"},{"v":752.0827732131725,"d":"752.08"},{"v":918.718931847863,"d":"918.72"},{"v":12.96309532903134,"d":"13.0"},179,256,{"v":94449.59687680002,"d":"94450"},{"v":135078.75307520002,"d":"135079"},{"v":134622.81640515788,"d":"134623"},{"v":192533.18994257215,"d":"192533"},{"v":15.476330532648474,"d":"15.5"},{"v":129.5613792,"d":"129.56"},{"v":88.39566871352925,"d":"88.4"}]
[11,"Административно-бытовой кор.",{"v":142.34489280000003,"d":"142.34"},{"v":179.62498101850406,"d":"179.62"},{"v":229.1881373722066,"d":"229.19"},{"v":6.732961340126892,"d":"6.7"},25,68,{"v":3558.6223200000004,"d":"3559"},{"v":9679.4527104,"d":"9679"},{"v":4490.624525462601,"d":"4491"},{"v":12214.498709258276,"d":"12214"},{"v":7.563425676747042,"d":"7.6"},{"v":10.6748928,"d":"10.67"},{"v":26.997536282524074,"d":"27.0"}]
[12,"Цех металлоизделий",{"v":240.16342,"d":"240.16"},{"v":244.16611194931406,"d":"244.17"},{"v":342.48439165973883,"d":"342.48"},{"v":8.745579775240493,"d":"8.7"},30,24,{"v":7204.9026,"d":"7205"},{"v":5763.92208,"d":"5764"},{"v":7324.983358479421,"d":"7325"},{"v":5859.986686783537,"d":"5860"},{"v":8.81815787248747,"d":"8.8"},{"v":30.69792,"d":"30.70"},{"v":46.01554724695376,"d":"46.0"}]
[null,"Итого",{"v":15645.3244856,"d":"15645.32"},{"v":14557.837293427698,"d":"14557.84"},{"v":21370.699682547343,"d":"21370.70"},{"$nulls":3},{"v":3931475.5335008004,"d":"3931476"},{"v":3120142.4880704,"d":"3120142"},{"v":3520343.493419911,"d":"3520343"},{"v":2979269.152457079,"d":"2979269"}]
[null,"Координаты ЦЭН",{"$nulls":3},"Акт.нагр",{"v":251.2875675489723,"d":"251.3"},{"v":214.32733620941238,"d":"214.3"},"Реакт. Наг",{"v":241.81775235317474,"d":"241.8"},{"v":139.40905991440877,"d":"139.41"}]

{"sheet":"Потери ГПП","index":9,"n_rows":41,"n_cols":19,"rows_kept":41,"merged":[[2,0,2,8],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,6,4,6],[3,7,3,8],[3,12,4,12],[9,0,9,5],[10,0,10,5],[11,0,11,5],[12,0,13,0],[17,0,17,1],[17,2,17,3],[17,4,17,5],[18,0,18,1],[18,2,18,3],[18,4,18,5],[19,0,19,1],[19,2,19,3],[19,4,19,5],[20,0,20,1],[20,2,20,3],[20,4,20,5],[21,0,21,1],[21,2,21,3],[21,4,21,5]],"flags":["formulas_cached_only"]}
["Таблица 5.2"]
[]
["           Потери мощности в трансформаторах ГПП"]
["Тип тр-ра","Мощность тр-ров  S, кВА","Кол-во тр-ров","Рр             кВт","Qр           кВт","Sp","kз.р","Расчетные потери",{"$nulls":4},"Тип трансформатора","Sном ","Uк","Ркз","Рхх","I x"]
[{"$nulls":5},"кВА",null,"Рр         кВт","Qр              кВАр",{"$nulls":4},"МВА","%","кВт","кВт","%"]
["ТДН",16000,2,{"v":15952.734677381519,"d":"15953"},{"v":2178.6583355066214,"d":"2179"},{"v":16100.81661996693,"d":"16101"},{"v":0.5031505193739666,"d":"0.503"},{"v":95.0372756748697,"d":"95.04"},{"v":1122.619095691542,"d":"1122.62"},{"$nulls":3},"ТРДН-25000/10",16,10.5,120,30,0.75]
["ТДН",10000,2,{"v":15952.734677381519,"d":"15953"},{"v":2178.6583355066214,"d":"2179"},{"v":16100.81661996693,"d":"16101"},{"v":0.8050408309983466,"d":"0.805"},{"v":93.770888748941,"d":"93.8"},{"v":1540.9905531064676,"d":"1541.0"},{"$nulls":3},"ТДН-25000/10",25,10.5,120,27,0.7]
[]
[{"$nulls":12},"ТДН-1600/10",10000,10.5,90,26,0.85]
["Таблица 5.1",{"$nulls":11},"ТМ-1000/6",630,5.5,7.6,1.42,2]
[{"$nulls":12},"ТМ-1000/10",1000,5.5,18,2.8,1.5]
["Технические данные трансформаторов ГПП"]
["Тип трансформатора","Sном","Uк","Ркз","Рхх","I x",{"$nulls":7},10000,16000]
[null,"МВА","%","кВт","кВт","%",null,"Qxx","Qкз",{"$nulls":3},"Qxx",136,75]
["ТДН-16000/35",16000,10.5,85,26,0.85,null,136,1680,{"$nulls":3},"Qкз",1680,1050]
["ТДН-10000/35",10000,10.5,60,8,0.9,null,90.00000000000001,1050,null,0]
[{"$nulls":16},"потери"]
[null,null,"Холостой ход",null,"Короткое замыкание",{"$nulls":7},"Стоимость потерь",8760,7000,227760,{"v":159491.08044216418,"d":"159491"},{"v":387.2510804421642,"d":"387.25"},1742.6298619897389]
["Часов в году",null,8760,null,7000,{"$nulls":7},"1000 кВа",null,null,227760,{"v":136099.05531064677,"d":"136099"},{"v":363.8590553106468,"d":"363.86"},1637.3657488979106]
["Ст-сть потреь 1 кВ (тенге)",null,10,null,10]
["Потерь кВт/год",null,227760,null,{"v":150630.46486204394,"d":"150630"}]
["Ст-сть потерь в год (тг.)",null,2277600,null,{"v":1506304.6486204395,"d":"1506305"},{"$nulls":7},"Стоимость ",20636.399999999998]
[{"$nulls":13},18010.199999999997]
["Реактив сопр","Активн соп"]
[]
[{"$nulls":12},"Срок окуп",9.036144578313253]
["Хт","Rt"]
[1.05,0.053125000000000006,{"$nulls":10},"коэф ",0.11066666666666666]
[]
[]
[{"$nulls":13},0.005625,0.03515625]
[]
[{"$nulls":13},0.783,0.035,44.74285714285714]
[]
[{"$nulls":13},1.02,0.98,-0.06704980842911878,1.9364068228090274,19.194245349729922]
[{"$nulls":16},0.9364068228090274]
[{"$nulls":16},1.6594322750888615,11.665808893874697]
[]
[{"$nulls":13},127.71392081736909]
[]
[{"$nulls":13},24000,360000,0.03333333333333333]

{"sheet":"ТЭР","index":10,"n_rows":35,"n_cols":15,"rows_kept":35,"merged":[[0,1,0,6],[1,1,1,6],[2,1,3,1],[2,2,3,2],[2,3,2,4],[2,5,2,6],[8,14,8,20],[9,19,9,20],[10,19,10,20],[11,19,11,20],[12,19,12,20],[13,19,13,20],[14,19,14,20],[15,19,15,20],[16,19,16,20],[17,19,17,20],[18,19,18,20],[19,19,19,20],[20,1,20,6],[20,15,20,16],[20,19,20,20],[21,1,21,6],[22,1,23,1]],"flags":["formulas_cached_only"]}
[null,"Таблица 6.1"]
[null,"Постоянная часть затрат ПС"]
[null,"Наименование оборудования ","Стоимость единицы, тыс. тенге","Первый вариант",null,"Второй вариант"]
[{"$nulls":3},"Кол-во","Общая стоимость тыс. тенге","Кол-во","Общая стоимость, тыс. тенге"]
[null,"Ячейки КРУ",2030,24,48720,30,60900]
[null,"Реакторы одинарные РБА-6 кВ",2810,4,11240,"-","-"]
[null,"Реакторы сдвоенные РБАС-6 кВ",3750,"-","-",2,7500,{"$nulls":7},5]
[null,"ИТОГО","-","-",59960,"-",68400]
[]
[]
[]
[]
[]
[null,"Амортизация (9,4+5)%",0.144,8634.24,null,null,{"v":9849.599999999999,"d":"9849.60"}]
[null,"Потери Э\\э"]
[null,"сумма эксплуатационных",null,8634.24,null,null,{"v":9849.599999999999,"d":"9849.60"}]
[]
[null,"приведенные ",null,16129.24,null,null,{"v":18399.6,"d":"18399.60"}]
[]
[]
[null,"Таблица 5.1"]
[null,"Технические данные трансформаторов ГПП"]
[null,"Тип трансформатора","Sном","Uк","Ркз","Рхх","I x"]
[null,null,"МВА","%","кВт","кВт","%"]
[null,"ТДН-16000/110",16000,10.5,85,26,0.85]
[null,"ТДН-10000/110",4000,10.5,60,8,0.9]
[]
[null,"расчет потерь","8760*Pxx","Кз","t",null,"стоимость потерь"]
[null,6.3,227760,{"v":0.8050408309983466,"d":"0.81"},7500,1281835.6929574981,8806211.210618012,8806.211210618012]
[null,4,70080,{"v":0.5031505193739666,"d":"0.50"},7500,368004.40063166304,2528190.232339525,2528.190232339525]
[]
[null,"Приведенные затраты 6,3",{"$error":"#REF!"}]
[null,"Приведенные затраты 4,0",{"$error":"#REF!"}]
[]
[null,"Эконом эффект , срок окупаем",null,{"$error":"#REF!"},0,{"$error":"#REF!"}]

{"sheet":"КЗ 6-10 по ТП","index":11,"n_rows":23,"n_cols":17,"rows_kept":23,"merged":[[1,0,1,14],[13,0,13,4],[14,0,14,4],[15,0,16,0]],"flags":["formulas_cached_only"]}
["Таблица 7.3"]
["        Расчет токов КЗ по цеховым подстанциям на 6 кВ"]
["№ ТП","Хрез ","Rрез ","Длина кабеля L, км","Хо, Ом/км","Ro, Ом/км","Относит сопр. кабеля Х*, ","Относит сопр. кабеля    R*, ","Результ сопрот Х* до тр-ра ТП","Результ сопрот R* до тр-ра ТП","Полное сопрот, Zрез","Начальный периодич ток Iпо, кА","Мгновенный ударный ток iу, кА","Ударный коэффициент","Апериодический ток Iа0 кА","Действ знач. ударного тока Iу, кА","Мощность КЗ МВА"]
["ТП-1",7.632,0.332,0.1286,0.076,0.258,{"v":0.08864943310657596,"d":"0.089"},{"v":0.3009414965986395,"d":"0.301"},{"v":7.720649433106575,"d":"7.721"},{"v":0.6329414965986395,"d":"0.633"},{"v":7.746550368199087,"d":"7.747"},{"v":12.36034046755445,"d":"12.36"},{"v":30.986230944063717,"d":"30.99"},{"v":1.7729190654354532,"d":"1.77"},{"v":17.477521421121992,"d":"17.48"},{"v":18.311700539213994,"d":"18.31"},{"v":12.908971767680887,"d":"12.91"}]
["ТП-2",7.632,0.332,0.018,0.076,0.258,{"v":0.01240816326530612,"d":"0.012"},{"v":0.04212244897959184,"d":"0.042"},{"v":7.644408163265306,"d":"7.644"},{"v":0.37412244897959185,"d":"0.374"},{"v":7.653557589345476,"d":"7.654"},{"v":12.510521921634673,"d":"12.51"},{"v":32.85839162686333,"d":"32.86"},{"v":1.8574685270345088,"d":"1.86"},{"v":17.689877997191427,"d":"17.69"},{"v":19.663836624257183,"d":"19.66"},{"v":13.065819239305142,"d":"13.07"}]
["ТП-3",7.632,0.332,0.039,0.076,0.258,{"v":0.0268843537414966,"d":"0.027"},{"v":0.09126530612244897,"d":"0.091"},{"v":7.658884353741496,"d":"7.659"},{"v":0.423265306122449,"d":"0.423"},{"v":7.670571234487899,"d":"7.671"},{"v":12.482773065126542,"d":"12.48"},{"v":32.48775237919643,"d":"32.49"},{"v":1.8405989997306307,"d":"1.84"},{"v":17.65064111408893,"d":"17.65"},{"v":19.391389749403725,"d":"19.39"},{"v":13.036838710314926,"d":"13.04"}]
["ТП-4",7.632,0.332,0.006,0.076,0.258,{"v":0.004136054421768708,"d":"0.004"},{"v":0.014040816326530613,"d":"0.014"},{"v":7.636136054421768,"d":"7.636"},{"v":0.3460408163265306,"d":"0.346"},{"v":7.6439726640147,"d":"7.644"},{"v":12.526209107308741,"d":"12.53"},{"v":33.07353702386506,"d":"33.07"},{"v":1.867289159229803,"d":"1.87"},{"v":17.71205967773456,"d":"17.71"},{"v":19.823021637225708,"d":"19.82"},{"v":13.08220272303785,"d":"13.08"}]
["ТП-5",7.632,0.332,0.142,0.076,0.258,{"v":0.09788662131519274,"d":"0.098"},{"v":0.3322993197278911,"d":"0.332"},{"v":7.729886621315193,"d":"7.730"},{"v":0.6642993197278911,"d":"0.664"},{"v":7.75837874588361,"d":"7.758"},{"v":12.341495966641537,"d":"12.34"},{"v":30.772259708846338,"d":"30.77"},{"v":1.7633648275759675,"d":"1.76"},{"v":17.450875296831132,"d":"17.45"},{"v":18.16109617398019,"d":"18.16"},{"v":12.889290826779673,"d":"12.89"}]
["ТП-6",7.632,0.332,0.092,0.076,0.258,{"v":0.06341950113378685,"d":"0.063"},{"v":0.2152925170068027,"d":"0.215"},{"v":7.695419501133786,"d":"7.695"},{"v":0.5472925170068027,"d":"0.547"},{"v":7.714856472910032,"d":"7.715"},{"v":12.41111877274928,"d":"12.41"},{"v":31.584399541795936,"d":"31.58"},{"v":1.7997504200664085,"d":"1.80"},{"v":17.54932194466748,"d":"17.55"},{"v":18.737096341417523,"d":"18.74"},{"v":12.962003940208126,"d":"12.96"}]
["ТП-7",7.632,0.332,0.105,0.076,0.258,{"v":0.07238095238095238,"d":"0.072"},{"v":0.24571428571428572,"d":"0.246"},{"v":7.704380952380952,"d":"7.704"},{"v":0.5777142857142857,"d":"0.578"},{"v":7.726010591199627,"d":"7.726"},{"v":12.39320071720647,"d":"12.39"},{"v":31.369597828708702,"d":"31.37"},{"v":1.7900949111368691,"d":"1.79"},{"v":17.523985814129947,"d":"17.52"},{"v":18.583603182858628,"d":"18.58"},{"v":12.943290566273076,"d":"12.94"}]
[]
[]
[]
["Таблица 7.1"]
["Сводная таблица токов КЗ"]
["Точка КЗ","IПО","iУ","IУ","Iап","SКЗ"]
[null,"кА","кА","кА","кА","МВА"]
["К-1 (110)",4.714,10.72,6.217,6.666,937.2]
["К-2 (110)",13.655,30.785,18.214,19.308,131.03]
["К-3 (6)",{"v":11.893,"d":"11.89"},30.82,18.37,16.817,130.05,null,"Ta ДСП"]
["К-4 (6)",{"v":11.192,"d":"11.19"},23.65,{"v":13.655,"d":"13.66"},15.825,122.38,null,0.5297648211660951]
["К-5 (0,4)",{"v":15.035,"d":"15.04"},21.69,15.04,21.26,{"v":65.027,"d":"65.03"}]
["К-6 (6)",10.57,{"v":28.457,"d":"28.46"},{"v":17.156,"d":"17.16"},14.95,{"v":115.6,"d":"115.60"}]

{"sheet":"ударный коэф10 kb","index":12,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[0,0,0,6],[1,0,1,4]],"flags":["formulas_cached_only"]}
["Таблица 8.3"]
["Расчет ударных коэффициентов для токов КЗ по цеховым подстанциям на 10 кВ"]
["№ ТП","Хрез до ТП","Rрез до ТП","Хрез/Rрез","Ударный коэффициент  Куд","Постоянная времени"]
["ТП-1",{"v":7.720649433106575,"d":"7.721"},{"v":0.6329414965986395,"d":"0.633"},{"v":12.19804590881863,"d":"12.20"},{"v":1.7729190654354532,"d":"1.77"},{"v":0.03884727996439054,"d":"0.039"}]
["ТП-2",{"v":7.644408163265306,"d":"7.644"},{"v":0.37412244897959185,"d":"0.374"},{"v":20.43290421121536,"d":"20.43"},{"v":1.8574685270345088,"d":"1.86"},{"v":0.06507294334781961,"d":"0.065"}]
["ТП-3",{"v":7.658884353741496,"d":"7.659"},{"v":0.423265306122449,"d":"0.423"},{"v":18.094760527161682,"d":"18.09"},{"v":1.8405989997306307,"d":"1.84"},{"v":0.05762662588268051,"d":"0.058"}]
["ТП-4",{"v":7.636136054421768,"d":"7.636"},{"v":0.3460408163265306,"d":"0.346"},{"v":22.067154203035305,"d":"22.07"},{"v":1.867289159229803,"d":"1.87"},{"v":0.07027756115616339,"d":"0.070"}]
["ТП-5",{"v":7.729886621315193,"d":"7.730"},{"v":0.6642993197278911,"d":"0.664"},{"v":11.636150138587364,"d":"11.64"},{"v":1.7633648275759675,"d":"1.76"},{"v":0.037057802989131736,"d":"0.037"}]
["ТП-6",{"v":7.695419501133786,"d":"7.695"},{"v":0.5472925170068027,"d":"0.547"},{"v":14.060889308738957,"d":"14.06"},{"v":1.7997504200664085,"d":"1.80"},{"v":0.04477990225713044,"d":"0.045"}]
["ТП-7",{"v":7.704380952380952,"d":"7.704"},{"v":0.5777142857142857,"d":"0.578"},{"v":13.335970985822618,"d":"13.34"},{"v":1.7900949111368691,"d":"1.79"},{"v":0.04247124517777904,"d":"0.042"}]

{"sheet":"КЗ 0,4 по ТП","index":13,"n_rows":16,"n_cols":21,"rows_kept":16,"merged":[[1,0,1,16],[2,0,3,0],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[3,22,3,27],[4,22,5,22],[10,18,10,22],[11,18,11,22],[12,18,13,18]],"flags":["formulas_cached_only"]}
["Таблица 7.2"]
["         Расчет токов КЗ на шинах ТП на 0,4 кВ"]
["№ ТП","Результирующие  сопротивления до    тр-ра в относит един.",null,"Результирующие  сопротивления до тр-ра в именованных един.",null,"Относительные сопротивления  тр-ра 10/0,4",null,"Именованные сопротивления тр-ра 10/0,4",null,"Результирующее реактивное сопротивление в точке КЗ X, мОм","Результирующее активное сопротивление в точке КЗ R, мОм","Полное сопрот, Zрез, мОм","Начальный периодич ток Iпо, кА","Апериодическая составляющая ia0, кА","Мгновенный ударный ток iу, кА","Действующий ударный ток Iу, кА","Ударный коэффициент"]
[null,"Хрез","Rрез","Х     мОм"," R   мОм","Xт* "," Rт*","Хт, мОм"," Rт, мОм",{"$nulls":9},"мощн тр-тр 1000","Рк, кВт","напр КЗ"]
["ТП-1",{"v":7.720649433106575,"d":"7.721"},{"v":0.6329414965986395,"d":"0.633"},{"v":1.2353039092970521,"d":"1.235"},{"v":0.10127063945578232,"d":"0.101"},{"v":0.06402780645938139,"d":"0.064"},0.0112,{"v":10.244449033501022,"d":"10.244"},1.792,{"v":11.479752942798074,"d":"11.480"},{"v":16.893270639455782,"d":"16.89"},{"v":20.424674306474994,"d":"20.42"},{"v":11.320321164635216,"d":"11.320"},{"v":16.006934126794192,"d":"16.01"},{"v":16.520185701173933,"d":"16.52"},{"v":11.331953848658761,"d":"11.33"},{"v":1.0320643272668064,"d":"1.03"},15,1000,11.2,6.5]
["ТП-2",{"v":7.644408163265306,"d":"7.644"},{"v":0.37412244897959185,"d":"0.374"},{"v":1.223105306122449,"d":"1.223"},{"v":0.0598595918367347,"d":"0.060"},{"v":0.06402780645938139,"d":"0.064"},0.0112,{"v":10.244449033501022,"d":"10.244"},1.792,{"v":11.46755433962347,"d":"11.468"},{"v":16.851859591836735,"d":"16.85"},{"v":20.383571184539694,"d":"20.38"},{"v":11.343148398242331,"d":"11.343"},{"v":16.039211835114656,"d":"16.04"},{"v":16.55469036080798,"d":"16.55"},{"v":11.354858606169861,"d":"11.35"},{"v":1.0321386444042586,"d":"1.03"},{"$nulls":3},0.065]
["ТП-3",{"v":7.658884353741496,"d":"7.659"},{"v":0.423265306122449,"d":"0.423"},{"v":1.2254214965986392,"d":"1.225"},{"v":0.06772244897959183,"d":"0.068"},{"v":0.06402780645938139,"d":"0.064"},0.0112,{"v":10.244449033501022,"d":"10.244"},1.792,{"v":11.46987053009966,"d":"11.470"},{"v":16.859722448979593,"d":"16.86"},{"v":20.391374917691916,"d":"20.39"},{"v":11.338807400954837,"d":"11.339"},{"v":16.033073664950138,"d":"16.03"},{"v":16.548127919451826,"d":"16.55"},{"v":11.350502821463802,"d":"11.35"},{"v":1.0321244862504217,"d":"1.03"},null,"Rт*=Рк/Sнт",null,0.0112]
["ТП-4",{"v":7.636136054421768,"d":"7.636"},{"v":0.3460408163265306,"d":"0.346"},{"v":1.2217817687074828,"d":"1.222"},{"v":0.0553665306122449,"d":"0.055"},{"v":0.06402780645938139,"d":"0.064"},0.0112,{"v":10.244449033501022,"d":"10.244"},1.792,{"v":11.466230802208505,"d":"11.466"},{"v":16.847366530612245,"d":"16.85"},{"v":20.379112047052217,"d":"20.38"},{"v":11.34563038362677,"d":"11.346"},{"v":16.04272136244825,"d":"16.04"},{"v":16.558442631518083,"d":"16.56"},{"v":11.357349055830577,"d":"11.36"},{"v":1.0321467447709338,"d":"1.03"},"Хт*=корень из uk2-Rn2",null,null,{"v":0.06402780645938139,"d":"0.064"}]
["ТП-5",{"v":7.729886621315193,"d":"7.730"},{"v":0.6642993197278911,"d":"0.664"},{"v":1.2367818594104307,"d":"1.237"},{"v":0.10628789115646259,"d":"0.106"},{"v":0.06402780645938139,"d":"0.064"},0.0112,{"v":10.244449033501022,"d":"10.244"},1.792,{"v":11.481230892911453,"d":"11.481"},{"v":16.898287891156464,"d":"16.90"},{"v":20.429654829897384,"d":"20.43"},{"v":11.31756139580021,"d":"11.318"},{"v":16.003031813661497,"d":"16.00"},{"v":16.51601483706369,"d":"16.52"},{"v":11.32918474674112,"d":"11.33"},{"v":1.032055364844321,"d":"1.03"}]
["ТП-6",{"v":7.695419501133786,"d":"7.695"},{"v":0.5472925170068027,"d":"0.547"},{"v":1.2312671201814058,"d":"1.231"},{"v":0.08756680272108844,"d":"0.088"},{"v":0.06402780645938139,"d":"0.064"},0.0112,{"v":10.244449033501022,"d":"10.244"},1.792,{"v":11.475716153682427,"d":"11.476"},{"v":16.87956680272109,"d":"16.88"},{"v":20.411071424288625,"d":"20.41"},{"v":11.327865550322443,"d":"11.328"},{"v":16.017601888155934,"d":"16.02"},{"v":16.531588352215582,"d":"16.53"},{"v":11.339523791522728,"d":"11.34"},{"v":1.0320888524792036,"d":"1.03"}]
["ТП-7",{"v":7.704380952380952,"d":"7.704"},{"v":0.5777142857142857,"d":"0.578"},{"v":1.2327009523809525,"d":"1.233"},{"v":0.09243428571428572,"d":"0.092"},{"v":0.06402780645938139,"d":"0.064"},0.0112,{"v":10.244449033501022,"d":"10.244"},1.792,{"v":11.477149985881974,"d":"11.477"},{"v":16.884434285714285,"d":"16.88"},{"v":20.415902942241733,"d":"20.42"},{"v":11.325184758494052,"d":"11.325"},{"v":16.01381124851059,"d":"16.01"},{"v":16.527536453734665,"d":"16.53"},{"v":11.336833911039221,"d":"11.34"},{"v":1.032080133657867,"d":"1.03"}]
[]
[]
[]
["x","r","z","Iпо","ky","iy","Iy","Ia","Sкз"]
[11.513,17.107,{"v":20.620344759484503,"d":"20.620"},11.212900440281008,1.0315568924908218,16.355377053855133,11.224061112272514,15.855041222557343,48.49579440421535]

{"sheet":"ударный 0,4 кВ","index":14,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,0,1,4]],"flags":["formulas_cached_only"]}
[]
["Расчет ударных коэффициентов для токов КЗ по цеховым подстанциям на 0,4 кВ"]
["№ ТП","Хрез до ТП","Rрез до ТП","Хрез/Rрез","Ударный коэффициент  Куд","Постоянная времени"]
["ТП-1",{"v":11.479752942798074,"d":"11.480"},{"v":16.893270639455782,"d":"16.893"},{"v":0.6795459084155119,"d":"0.680"},{"v":1.0318230407214704,"d":"1.03"},{"v":0.002164158943998445,"d":"0.00216"}]
["ТП2",{"v":11.46755433962347,"d":"11.468"},{"v":16.851859591836735,"d":"16.852"},{"v":0.6804919229910096,"d":"0.680"},{"v":1.0318958715161735,"d":"1.03"},{"v":0.0021671717292707313,"d":"0.00217"}]
["ТП-3",{"v":11.46987053009966,"d":"11.470"},{"v":16.859722448979593,"d":"16.860"},{"v":0.680311942548844,"d":"0.680"},{"v":1.0318819965254133,"d":"1.03"},{"v":0.002166598543149185,"d":"0.00217"}]
["ТП-4",{"v":11.466230802208505,"d":"11.466"},{"v":16.847366530612245,"d":"16.847"},{"v":0.6805948443855584,"d":"0.681"},{"v":1.031903809875515,"d":"1.03"},{"v":0.002167499504412606,"d":"0.00217"}]
["ТП-5",{"v":11.481230892911453,"d":"11.481"},{"v":16.898287891156464,"d":"16.898"},{"v":0.6794316067321845,"d":"0.679"},{"v":1.0318142575474345,"d":"1.03"},{"v":0.0021637949258986764,"d":"0.00216"}]
["ТП-6",{"v":11.475716153682427,"d":"11.476"},{"v":16.87956680272109,"d":"16.880"},{"v":0.6798584518076892,"d":"0.680"},{"v":1.0318470754296194,"d":"1.03"},{"v":0.0021651543051200294,"d":"0.00217"}]
["ТП-7",{"v":11.477149985881974,"d":"11.477"},{"v":16.884434285714285,"d":"16.884"},{"v":0.6797473810296772,"d":"0.680"},{"v":1.0318385309847098,"d":"1.03"},{"v":0.0021648005765276344,"d":"0.00216"}]

{"sheet":"Кабели","index":15,"n_rows":35,"n_cols":20,"rows_kept":35,"merged":[[0,0,0,10],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,1,13],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[41,1,41,9],[43,1,45,1],[43,2,43,7],[44,4,44,6]],"flags":["formulas_cached_only"]}
["Таблица 8.1 Выбор силовых кабелей напряжением 6 кВ к узлам питания"]
["Наименование пунктов питания, электроприемников              10 кВ","Номиналнапряжение, кВ ","Ток КЗ для  ступени, Iпо, кА","Токи номин /расчетный Ipa, А","Тепловой импульс КЗ, Вк ка2с","Выбор по Iдоп., A","Выбор по эконом плотности, мм2","Выбор по термической мм2\n","Выбранное сечение кабеля, мм2","Допустимый ток кабеля Iдоп, А","Время защит       с","Расчетные сечения кабелей"]
[{"$nulls":11},"по току сечение","по экономич плотн.","по току КЗ"]
["ТП-1",6,{"v":12.36034046755445,"d":"12.36"},{"v":44.438948277443465,"d":"44.44"},{"v":99.89349050979091,"d":"99.9"},{"v":46.58170678977302,"d":"46.58"},{"v":37.03245689786956,"d":"37.03"},{"v":108.6377511597819,"d":"108.6"},"ААШвУ-(3х120)",260,0.6,16,50,120,{"$nulls":4},153,153]
["ТП-2",6,{"v":12.510521921634673,"d":"12.51"},{"v":48.30737766296333,"d":"48.31"},{"v":106.44036454493435,"d":"106.4"},{"v":50.63666421694269,"d":"50.64"},{"v":40.25614805246945,"d":"40.26"},{"v":114.63326631605761,"d":"114.6"},"ААШвУ-(3х120)",260,0.6,16,50,120,{"$nulls":4},189,160]
["ТП-3",6,{"v":12.482773065126542,"d":"12.48"},{"v":48.30737766296333,"d":"48.31"},{"v":104.80842753079065,"d":"104.8"},{"v":50.63666421694269,"d":"50.64"},{"v":40.25614805246945,"d":"40.26"},{"v":113.75109687751741,"d":"113.8"},"ААШвУ-(3х120)",260,0.6,16,50,120,{"$nulls":4},178,167]
["ТП-4",6,{"v":12.526209107308741,"d":"12.53"},{"v":48.87315010266897,"d":"48.87"},{"v":107.52410248808201,"d":"107.5"},{"v":46.106745379876386,"d":"46.11"},{"v":40.72762508555748,"d":"40.73"},{"v":115.21536596341738,"d":"115.2"},"ААШвУ-(3х120)",260,0.6,16,50,120,{"$nulls":4},184,184]
["ТП-5",6,{"v":12.341495966641537,"d":"12.34"},{"v":50.24809523191822,"d":"50.25"},{"v":99.31656891599225,"d":"99.3"},{"v":52.67095936259771,"d":"52.67"},{"v":41.87341269326519,"d":"41.87"},{"v":110.73077622975234,"d":"110.7"},"ААШвУ-(3х120)",260,0.6,16,50,120,null,20.663319087626245,null,null,193,191]
["ТП-6",6,{"v":12.41111877274928,"d":"12.41"},{"v":49.94026535298841,"d":"49.94"},{"v":101.62977071912117,"d":"101.6"},{"v":52.348286533530825,"d":"52.35"},{"v":41.61688779415701,"d":"41.62"},{"v":112.01287994675243,"d":"112.0"},"ААШвУ-(3х120)",260,0.6,16,50,120,{"$nulls":4},207,208]
["ТП-7",6,{"v":12.39320071720647,"d":"12.39"},{"v":44.400387392693645,"d":"44.40"},{"v":100.9819447970635,"d":"101.0"},{"v":46.541286575150565,"d":"46.54"},{"v":37.00032282724471,"d":"37.00"},{"v":111.65530334502508,"d":"111.7"},"ААШвУ-(3х120)",260,0.6,16,50,120,{"$nulls":4},1104,1063]
["СД,1000 кВт, ",6,{"v":13.655,"d":"13.66"},{"v":111.50360379647472,"d":"111.50"},{"v":90.48438090755609,"d":"90.5"},{"v":131.49009881659754,"d":"131.49"},{"v":92.9196698303956,"d":"92.92"},{"v":105.69253153915405,"d":"105.7"},"ААШвУ-(3х95)",225,0.4,70,95,120]
["ДСП,2500 кВт ",6,10.57,{"v":240.84778420038538,"d":"240.85"},{"v":105.5800305,"d":"105.6"},{"v":284.01861344385065,"d":"284.02"},{"v":200.70648683365448,"d":"200.71"},{"v":114.16904863695181,"d":"114.2"},"ААШвУ-(3х240)",300,0.4,150,240,185]
[]
[]
[]
["Наименование узла ","Марка, сечение кабеля к узлу",null,"Uном, кВ","Длина КЛ, км","X0  Ом/км","R0  Ом/км",null,"алюмин 6-10 кВ","X0","R0"]
["ТП-1","ААШвУ-(3х120)",null,6,0.1286,0.076,0.258,null,16,0.102,1.94]
["ТП-2","ААШвУ-(3х120)",null,6,0.018,0.076,0.258,null,25,0.091,1.24]
["ТП-3","ААШвУ-(3х120)",null,6,0.039,0.076,0.258,null,35,0.087,0.89]
["ТП-4","ААШвУ-(3х120)",null,6,0.006,0.076,0.258,null,50,0.083,0.62]
["ТП-5","ААШвУ-(3х120)",null,6,0.142,0.076,0.258,null,70,0.08,0.443]
["ТП-6","ААШвУ-(3х120)",null,6,0.092,0.076,0.258,null,95,0.078,0.326]
["ТП-7","ААШвУ-(3х120)",null,6,0.105,0.076,0.258,null,120,0.076,0.258]
["СД,1000 кВт","ААШвУ-(3х95)",null,6,0.106,0.078,0.326,null,150,0.074,0.206]
["ДСП,2500 кВт","ААШвУ-(3х240)",null,6,0.008,0.071,0.129,null,185,0.073,0.167]
[{"$nulls":8},240,0.071,0.129]
[]
[]
[{"$nulls":11},"r0","x0"]
[{"$nulls":9},"3х25",65,1.24,0.099]
[{"$nulls":9},"3х50","140А",0.62,0.09]
[{"$nulls":9},"3х70",165,0.443,0.086]
[{"$nulls":9},"3х95",205,0.326,0.083]
[{"$nulls":9},"3х16",75,1.94,0.113]
[{"$nulls":9},"3х35","80А",0.89,0.095]

{"sheet":"Потери напряжения в КЛ","index":16,"n_rows":12,"n_cols":16,"rows_kept":12,"merged":[[0,0,0,11]],"flags":["formulas_cached_only"]}
["Таблица 8.2 Потери напряжения в кабелях"]
["Наименование узла ","Марка, сечение кабеля к узлу","Uном, кВ","Длина КЛ, км","X0  Ом/км","R0  Ом/км","Pр *(Рном), кВт","Qр       кВАр","Индукт. сопрот кабеля Хк  Ом","Активн. сопрот. кабеля   Rк, Ом","Потери напря-жения  B","Потери напря-жения  %",null,"Сечение","R0","X0"]
["ТП-1","ААШвУ-(3х120)",6,0.1286,0.076,0.258,{"v":912.9542128999365,"d":"913.0"},{"v":132.73222149787924,"d":"132.73"},{"v":0.009773599999999999,"d":"0.010"},{"v":0.0995364,"d":"0.100"},{"v":15.361574559487485,"d":"15.36"},{"v":0.25602624265812474,"d":"0.256"},null,16,1.94,0.102]
["ТП-2","ААШвУ-(3х120)",6,0.018,0.076,0.258,{"v":983.7415870748022,"d":"983.7"},{"v":194.89226937965654,"d":"194.89"},{"v":0.0013679999999999999,"d":"0.001"},{"v":0.013931999999999998,"d":"0.014"},{"v":2.328683402606252,"d":"2.33"},{"v":0.03881139004343754,"d":"0.039"},null,25,1.24,0.091]
["ТП-3","ААШвУ-(3х120)",6,0.039,0.076,0.258,{"v":983.7415870748022,"d":"983.7"},{"v":194.89226937965654,"d":"194.89"},{"v":0.002964,"d":"0.003"},{"v":0.030185999999999998,"d":"0.030"},{"v":5.04548070564688,"d":"5.05"},{"v":0.08409134509411466,"d":"0.084"},null,35,0.89,0.087]
["ТП-4","ААШвУ-(3х120)",6,0.006,0.076,0.258,{"v":999.6083882108554,"d":"999.6"},{"v":173.80913420144898,"d":"173.81"},{"v":0.000456,"d":"0.0005"},{"v":0.0046440000000000006,"d":"0.005"},{"v":0.7869063866745124,"d":"0.79"},{"v":0.013115106444575206,"d":"0.013"},null,50,0.62,0.083]
["ТП-5","ААШвУ-(3х120)",6,0.142,0.076,0.258,{"v":1033.6439520000001,"d":"1033.6"},{"v":140.50998706012513,"d":"140.51"},{"v":0.010792,"d":"0.011"},{"v":0.10990799999999999,"d":"0.110"},{"v":19.187020542794812,"d":"19.19"},{"v":0.3197836757132469,"d":"0.320"},null,70,0.443,0.08]
["ТП-6","ААШвУ-(3х120)",6,0.092,0.076,0.258,{"v":1028.782630838835,"d":"1028.8"},{"v":128.36435186646543,"d":"128.36"},{"v":0.006992,"d":"0.007"},{"v":0.07120800000000001,"d":"0.071"},{"v":12.359179520837015,"d":"12.36"},{"v":0.2059863253472836,"d":"0.206"},null,95,0.326,0.078]
["ТП-7","ААШвУ-(3х120)",6,0.105,0.076,0.258,{"v":906.2623192822848,"d":"906.3"},{"v":168.27191115063357,"d":"168.27"},{"v":0.00798,"d":"0.008"},{"v":0.08127000000000001,"d":"0.081"},{"v":12.499124756508891,"d":"12.50"},{"v":0.20831874594181485,"d":"0.208"},null,120,0.258,0.076]
["СД, 1000 кВт","ААШвУ-(3х95)",6,0.106,0.078,0.326,1000,{"v":906.7617865284449,"d":"906.76"},{"v":0.008268,"d":"0.008"},{"v":0.10366800000000001,"d":"0.104"},{"v":18.527517741836196,"d":"18.53"},{"v":0.3087919623639366,"d":"0.309"},null,150,0.206,0.074]
["ДСП, 2500 кВт ","ААШвУ-(3х240)",6,0.008,0.073,0.167,1600,1408,{"v":0.000584,"d":"0.001"},{"v":0.004008,"d":"0.004"},{"v":1.2058453333333334,"d":"1.21"},{"v":0.020097422222222223,"d":"0.020"},null,185,0.167,0.073]
[{"$nulls":13},240,0.129,0.071]

{"sheet":"Выключатели 6+ТТ","index":17,"n_rows":32,"n_cols":12,"rows_kept":32,"merged":[[0,0,0,8],[1,0,1,8],[2,0,3,0],[2,1,3,1],[2,2,2,3],[2,4,3,4],[2,5,2,9],[17,0,17,8],[18,0,18,8],[19,0,20,0],[19,1,20,1],[19,2,19,3],[19,4,20,4],[19,5,19,9]],"flags":["formulas_cached_only"]}
["Таблица 11.2"]
["        Выключатели 6 кВ"]
["Наименование присоединения","Расчетный послеавар.ток I,А","Токи короткого замыкания",null,"Тип выключателя","Технические данные выключателя"]
[null,null,"I по, кА","iу, кА",null,"Iном,А","Iпр.с, кА","iу, кА","Вк, кА2с","tнту, с",null,"Iр, а"]
["Вводной ЗРУ-6",{"v":1551.1384026943094,"d":"1551.14"},{"v":11.893,"d":"11.89"},30.82,"BB/TEL-10-25/1600У2",1600,25,64,1875,3,null,{"v":775.5692013471547,"d":"775.57"}]
["Секционный ЗРУ-6",{"v":775.5692013471547,"d":"775.57"},{"v":11.893,"d":"11.89"},30.82,"BB/TEL-10-25/1600У3",1600,25,64,1875,3,null,{"v":387.78460067357736,"d":"387.78"}]
["ТП-1",{"v":44.438948277443465,"d":"44.44"},{"v":12.36034046755445,"d":"12.36"},{"v":30.986230944063717,"d":"30.99"},"BB/TEL-10-20/630У2",630,20,51,1200,3,null,{"v":22.219474138721733,"d":"22.22"}]
["ТП-2",{"v":48.30737766296333,"d":"48.31"},{"v":12.510521921634673,"d":"12.51"},{"v":32.85839162686333,"d":"32.86"},"BB/TEL-10-20/630У2",630,20,51,1200,3,null,{"v":24.153688831481666,"d":"24.15"}]
["ТП-3",{"v":48.30737766296333,"d":"48.31"},{"v":12.482773065126542,"d":"12.48"},{"v":32.48775237919643,"d":"32.49"},"BB/TEL-10-20/630У2",630,20,51,1200,3,null,{"v":24.153688831481666,"d":"24.15"}]
["ТП-4",{"v":48.87315010266897,"d":"48.87"},{"v":12.526209107308741,"d":"12.53"},{"v":33.07353702386506,"d":"33.07"},"BB/TEL-10-20/630У2",630,20,51,1200,3,null,{"v":24.436575051334486,"d":"24.44"}]
["ТП-5",{"v":50.24809523191822,"d":"50.25"},{"v":12.341495966641537,"d":"12.34"},{"v":30.772259708846338,"d":"30.77"},"BB/TEL-10-20/630У2",630,20,51,1200,3,null,{"v":25.12404761595911,"d":"25.12"}]
["ТП-6",{"v":49.94026535298841,"d":"49.94"},{"v":12.41111877274928,"d":"12.41"},{"v":31.584399541795936,"d":"31.58"},"BB/TEL-10-20/630У2",630,20,51,1200,3,null,{"v":24.970132676494206,"d":"24.97"}]
["ТП-7",{"v":44.400387392693645,"d":"44.40"},{"v":12.39320071720647,"d":"12.39"},{"v":31.369597828708702,"d":"31.37"},"BB/TEL-10-20/630У2",630,20,51,1200,3,null,{"v":22.200193696346822,"d":"22.20"}]
["СД, 1000 кВт",{"v":111.50360379647472,"d":"111.50"},{"v":11.893,"d":"11.89"},30.82,"BB/TEL-10-20/630У2",630,20,51,1200,3,null,{"v":55.75180189823736,"d":"55.75"}]
["ДСП, 2500 кВт",{"v":240.84778420038538,"d":"240.85"},10.57,{"v":28.457,"d":"28.46"},"BB/TEL-10-20/630У2",630,20,51,1200,3,null,{"v":120.42389210019269,"d":"120.42"}]
[]
[]
["Таблица 11.2"]
["        Трансформаторы тока 6 и 110 кВ"]
["Наименование присоединения","Расчетный послеавар.ток I,А","Токи короткого замыкания",null,"Тип трансформатора тока","Технические данные выключателя"]
[null,null,"I по, кА","iу, кА",null,"Iном,А","iу, кА","Вк, кА2с","S2ном, ВА","Класс"]
["ТТ 110 кВ",{"v":86,"d":"86.00"},{"v":11.893,"d":"11.89"},30.82,"ТФЗМ110Б-1",150,30,48,100,1]
["Секционный",{"v":775.5692013471547,"d":"775.57"},{"v":11.893,"d":"11.89"},30.82,"ТОЛ-10",800,52,18,30,1]
["ТП-1",{"v":44.438948277443465,"d":"44.44"},{"v":12.36034046755445,"d":"12.36"},{"v":30.986230944063717,"d":"30.99"},"ТОЛ-10",150,52,18,30,1]
["ТП-2",{"v":48.30737766296333,"d":"48.31"},{"v":12.510521921634673,"d":"12.51"},{"v":32.85839162686333,"d":"32.86"},"ТОЛ-10",150,52,18,30,1]
["ТП-3",{"v":48.30737766296333,"d":"48.31"},{"v":12.482773065126542,"d":"12.48"},{"v":32.48775237919643,"d":"32.49"},"ТОЛ-10",150,52,18,30,1]
["ТП-4",{"v":48.87315010266897,"d":"48.87"},{"v":12.526209107308741,"d":"12.53"},{"v":33.07353702386506,"d":"33.07"},"ТОЛ-10",150,52,18,30,1]
["ТП-5",{"v":50.24809523191822,"d":"50.25"},{"v":12.341495966641537,"d":"12.34"},{"v":30.772259708846338,"d":"30.77"},"ТОЛ-10",150,52,18,30,1]
["ТП-6",{"v":49.94026535298841,"d":"49.94"},{"v":12.41111877274928,"d":"12.41"},{"v":31.584399541795936,"d":"31.58"},"ТОЛ-10",150,52,18,30,1]
["ТП-7",{"v":44.400387392693645,"d":"44.40"},{"v":12.39320071720647,"d":"12.39"},{"v":31.369597828708702,"d":"31.37"},"ТОЛ-10",150,52,18,30,1]
["СД, 1000 кВт",{"v":111.50360379647472,"d":"111.50"},{"v":11.893,"d":"11.89"},30.82,"ТОЛ-10",150,52,18,30,1]
["ДСП, 2500 кВт",{"v":240.84778420038538,"d":"240.85"},10.57,{"v":28.457,"d":"28.46"},"ТОЛ-10",150,52,18,30,1]

{"sheet":"Шины","index":18,"n_rows":17,"n_cols":20,"rows_kept":17,"merged":[[0,0,0,16],[1,0,1,16],[13,0,15,0],[13,1,13,4],[13,5,13,8],[13,9,13,10],[14,1,14,8],[14,9,15,9],[14,10,15,10],[16,0,18,0],[16,2,18,2],[16,3,18,3],[16,4,18,4],[16,6,18,6],[16,7,18,7],[16,8,18,8],[16,9,18,9],[16,10,18,10],[19,0,20,0],[19,5,20,5],[19,8,20,8],[19,9,20,9],[19,10,20,10]],"flags":["formulas_cached_only"]}
["Таблица 10.1"]
["            Расчет ошиновки "]
["Наименование узлов ","Sp,  кВА","Iр,  А","Длительно допустимый ток, Iдоп, А","Сеч. по длит. доп. току q, мм2","Iпо, кА","iу, кА","Тепл. импульс тока КЗ Вк, кА2 с","Мин. сеч. по КЗ qmin,мм2","Сечение по термической","Максимальное усилие  f, Н","Изгиб. момент       М, Нм","Момент сопротвленияW см3","Расч. напряжен. шин dрасч МПа","Допуст. напряжен. шин dДОП МПа","Окончательное .q, мм2","Время терм. стойк. tд,c ",null,"алюмин 1 полса на фазу"]
["ТП-1; 0,4 кВ",{"v":922.5525662397263,"d":"922.55"},{"v":666.5842241616518,"d":"666.58"},{"v":899.88870261823,"d":"899.89"},"80х6",{"v":11.320321164635216,"d":"11.320"},{"v":16.520185701173933,"d":"16.52"},{"v":76.8898027622928,"d":"76.89"},{"v":97.42981187633676,"d":"97.4"},"30х4",{"v":295.091004118875,"d":"295.1"},{"v":29.5091004118875,"d":"29.5"},6.4,{"v":4.610796939357422,"d":"4.61"},40,"80х6",0.6,null,"20x3",215]
["ТП-2; 0,4 кВ",{"v":1002.8611602831187,"d":"1002.86"},{"v":724.6106649444498,"d":"724.61"},{"v":978.2243976750073,"d":"978.22"},"80х6",{"v":11.343148398242331,"d":"11.343"},{"v":16.55469036080798,"d":"16.55"},{"v":77.20020935072853,"d":"77.20"},{"v":97.62627742211531,"d":"97.6"},"30х4",{"v":296.3249669937848,"d":"296.3"},{"v":29.632496699378482,"d":"29.6"},6.4,{"v":4.630077609277888,"d":"4.63"},40,"80х6",0.6,null,"25x3",265]
["ТП-3 0,4 кВ",{"v":1002.8611602831187,"d":"1002.86"},{"v":724.6106649444498,"d":"724.61"},{"v":978.2243976750073,"d":"978.22"},"80х6",{"v":11.338807400954837,"d":"11.339"},{"v":15.077456595367934,"d":"15.08"},{"v":77.1411319655689,"d":"77.14"},{"v":97.58891606611441,"d":"97.6"},"30х4",{"v":245.8002352977518,"d":"245.8"},{"v":24.580023529775183,"d":"24.6"},6.4,{"v":3.840628676527372,"d":"3.84"},40,"80х6",0.6,null,"30х4","365/370"]
["ТП-4;  0,4 кВ",{"v":1014.6065961314077,"d":"1014.61"},{"v":733.0972515400344,"d":"733.10"},{"v":989.6812895790466,"d":"989.68"},"80х6",{"v":11.34563038362677,"d":"11.346"},{"v":16.558442631518083,"d":"16.56"},{"v":77.23399728112494,"d":"77.23"},{"v":97.6476389511363,"d":"97.6"},"30х4",{"v":296.4593116997541,"d":"296.5"},{"v":29.64593116997541,"d":"29.6"},6.4,{"v":4.632176745308658,"d":"4.63"},40,"80х6",0.6,null,"40х4",480]
["ТП-5;  0,4 кВ",{"v":1043.1504570146221,"d":"1043.15"},{"v":753.7214284787732,"d":"753.72"},{"v":1017.5239284463439,"d":"1017.52"},"80х6",{"v":11.31756139580021,"d":"11.318"},{"v":16.51601483706369,"d":"16.52"},{"v":76.85231756862431,"d":"76.85"},{"v":97.4060595680315,"d":"97.4"},"30х4",{"v":294.9420192185792,"d":"294.9"},{"v":29.494201921857922,"d":"29.5"},6.4,{"v":4.6084690502903,"d":"4.61"},41,"80х6",0.6,null,"40х5",480]
["ТП-6;  0,4 кВ",{"v":1036.7599087280394,"d":"1036.76"},{"v":749.1039802948261,"d":"749.10"},{"v":1011.2903733980153,"d":"1011.29"},"80х6",{"v":11.327865550322443,"d":"11.328"},{"v":16.531588352215582,"d":"16.53"},{"v":76.99232275570918,"d":"76.99"},{"v":97.49474360994563,"d":"97.5"},"30х4",{"v":295.49850328968756,"d":"295.5"},{"v":29.549850328968756,"d":"29.5"},6.4,{"v":4.617164113901368,"d":"4.62"},42,"80х6",0.6,null,"50х5","540/545"]
["ТП-7;  0,4 кВ",{"v":921.75204227232,"d":"921.75"},{"v":666.0058108904045,"d":"666.01"},{"v":899.1078447020461,"d":"899.11"},"80х6",{"v":11.325184758494052,"d":"11.325"},{"v":16.527536453734665,"d":"16.53"},{"v":76.95588588841558,"d":"76.96"},{"v":97.47167102748784,"d":"97.5"},"30х4",{"v":295.3536674544274,"d":"295.4"},{"v":29.53536674544274,"d":"29.5"},6.4,{"v":4.614901053975428,"d":"4.61"},43,"80х6",0.6,null,"50х6","740/745"]
["ЗРУ-6 кВ",{"v":16100.81661996693,"d":"16100.82"},{"v":775.5692013471547,"d":"775.57"},{"v":1047.018421818659,"d":"1047.02"},"80х6",{"v":11.893,"d":"11.89"},30.82,{"v":169.7321388,"d":"169.73"},{"v":144.7569861424209,"d":"144.8"},"40х4",{"v":1027.0495325,"d":"1027.0"},{"v":102.70495324999999,"d":"102.7"},6.4,{"v":16.047648945312496,"d":"16.05"},40,"80х6",1.2,null,"60х6","870/880"]
[{"$nulls":18},"80х6","1150/1170"]
[]
[]
[]
[{"$nulls":18},0.3125]
[{"$nulls":14},16.6464,29.96352,null,null,13.632]

{"sheet":"Экономика","index":19,"n_rows":127,"n_cols":25,"rows_kept":127,"merged":[[1,0,2,0],[1,1,2,1],[1,2,1,5],[1,6,1,8],[1,9,1,12],[1,13,2,13],[13,0,13,12],[17,0,17,13],[18,0,19,0],[18,1,19,1],[18,2,18,5],[18,6,18,8],[18,9,18,12],[18,13,19,13],[18,15,18,16],[18,19,18,21],[41,0,42,0],[41,1,41,2],[41,8,44,8],[41,10,42,13],[41,17,42,17],[41,18,41,20],[41,21,42,21],[41,22,42,22],[41,23,42,23],[42,19,42,20],[43,10,44,10],[43,11,44,11],[43,12,43,13],[43,19,43,20],[44,12,44,13],[44,19,44,20],[45,12,45,13],[45,17,45,23],[46,12,46,13],[46,18,46,19],[47,12,47,13],[47,18,47,19],[48,8,48,10],[48,12,48,13],[48,18,48,19],[49,8,49,10],[49,12,49,13],[49,18,49,19],[50,8,50,10],[50,12,50,13],[50,18,50,19],[51,8,51,10],[51,12,51,13],[51,18,51,19],[52,8,53,10],[52,11,52,12],[52,13,52,14],[52,18,52,19],[53,11,53,12],[53,13,53,14],[53,18,53,19],[54,8,54,10],[54,11,54,12],[54,13,54,14],[54,18,54,19],[55,8,55,10],[55,11,55,12],[55,13,55,14],[55,18,55,19],[56,8,56,10],[56,11,56,12],[56,13,56,14],[57,8,57,10],[57,11,57,12],[57,13,57,14],[58,8,58,10],[58,11,58,12],[58,13,58,14],[59,8,59,10],[59,11,59,12],[59,13,59,14],[60,8,60,10],[60,11,60,12],[60,13,60,14],[61,8,61,10],[61,11,61,12],[61,13,61,14],[62,8,62,10],[62,11,62,12],[62,13,62,14],[63,8,63,10],[63,11,63,12],[63,13,63,14],[64,8,64,10],[64,11,64,12],[64,13,64,14],[68,2,68,5],[69,2,69,5],[70,3,72,3],[70,4,72,4],[70,10,70,14],[71,10,71,14],[77,11,77,13],[82,0,82,3],[101,0,101,2]],"flags":["formulas_cached_only"]}
["пример"]
["Наименование оборудования","Кол. единиц","Капитальный ремонт",{"$nulls":3},"Средний ремонт",null,null,"Текущий ремонт",{"$nulls":3},"Суммарная трудоемкость ремонтных работ, чел.ч."]
[null,null,"Ремонтный цикл, мес.","Норма ремонтов в году","Норма трудоемкости чел.ч","Годовая трудоемкость на группу оборудования, чел.ч","Норма ремонтов в году","Норма трудоемкости среднего ремонта чел.ч.","Годовая трудоемкость на группу оборудования чел.ч.","Межремонтный период, мес.","Норма ремонтов в году","Норма трудоемкости текущего ремонта, чел.ч.","Годовая трудоемкость на группу оборудования чел.ч."]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]
["ТД-10000/110/10",2,120,"1/10",420,84,"1/6",210,70,12,1,30,60,214,null,70]
["Выключатель 110кВ",2,36,"1/3",5,null,"1/3",4,2.6,12,1,8,16,21.9]
["Трансформатор тока 110 кВ",2,36,"1/3",12,8,"1/6",6,2,12,1,3.5,7,17]
["Разъединитель 110кВ",8,36,"1/3",3,8,"1/3",1.5,4,12,1,1,8,20]
["Трансформатор тока 10 кВ",23,36,"1/3",120,910.8,"1/6",60,230,12,1,16,368,1508.8]
["Выключатель нагрузки марки ВМПЭ",10,36,"1/3",8,26.4,"1/6",60,100,6,2,8,160,286.4]
["КЛ ",3.6,168,"1/14",90,23.1,null,"-","-",6,2,20,144,167.1]
["ТП-630-1000 кВА",7,180,"1/15",380,177.3,"1/6",190,212.8,36,"2012-03-01",36,83.2,473.3]
["Конденсаторные установки 0,4кВ",9,48,"1/4",45,101.2,"1/6",32,46.1,12,1,28,252,399.3]
[{"$nulls":13},3122]
[]
[]
[]
["Таблица 14.1 - Расчет плана годового объема ремонтных работ"]
["Наименование оборудования","Кол. единиц","Капитальный ремонт",{"$nulls":3},"Средний ремонт",null,null,"Текущий ремонт",{"$nulls":3},"Суммарная трудоемкость ремонтных работ, чел.ч.",null,"кап рем",null,"средний",null,"текущий"]
[null,null,"Ремонтный цикл, мес.","Норма ремонтов в году","Норма трудоемкости чел.ч","Годовая трудоемкость на группу оборудования, чел.ч","Норма ремонтов в году","Норма трудоемкости среднего ремонта чел.ч.","Годовая трудоемкость на группу оборудования чел.ч.","Межремонтный период, мес.","Норма ремонтов в году","Норма трудоемкости текущего ремонта, чел.ч.","Годовая трудоемкость на группу оборудования чел.ч.",null,null,"Норма ремонтов в году","Годовая трудоемкость на группу оборудования, чел.ч","Норма ремонтов в году","Годовая трудоемкость на группу оборудования чел.ч.","Межремонтный период, год","Норма ремонтов в году","Годовая трудоемкость на группу оборудования чел.ч."]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]
["ТД-10000-35/6",2,120,"1/10",420,84,"1/6",210,70,12,1,30,60,214,null,10,{"v":84,"d":"84.0"},"6",70,1,1,60]
["Выключатель 35кВ",2,36,"1/3",5,{"v":3.3333333333333335,"d":"3.3"},"1/3",4,{"v":2.6666666666666665,"d":"2.7"},12,1,8,16,22,null,3,{"v":3.3333333333333335,"d":"3.3"},"3",{"v":2.6666666666666665,"d":"2.7"},1,1,16]
["Трансформатор тока 35 кВ",2,36,"1/3",12,8,"1/6",6,2,12,1,3.5,7,17,null,3,{"v":8,"d":"8.0"},"6",2,1,1,7]
["Разъединитель 35кВ",8,36,"1/3",3,8,"1/3",1.5,4,12,1,1,8,20,null,3,{"v":8,"d":"8.0"},"3",4,1,1,8]
["Ячейка ЗРУ - 6 кВ с выключателем вакуумным ",20,48,"1/3",8,{"v":53.33333333333333,"d":"53.3"},"1/6",60,200,12,1,16,320,{"v":573.3333333333333,"d":"573"},null,3,{"v":53.33333333333333,"d":"53.3"},"6",200,1,1,320]
[{"$nulls":15},3,{"v":0,"d":"0.0"},"6",0,0.5,2,0]
["Кабельные линии 6 кВ",2.46,168,"1/14",90,{"v":15.814285714285715,"d":"15.8"},"-","-",0,6,2,20,24.6,{"v":40.41428571428572,"d":"40"},null,14,{"v":15.814285714285715,"d":"15.8"},"-",null,0.5,2,24.6]
["ТП-1000 кВА",4,60,"1/15",380,{"v":101.33333333333333,"d":"101.3"},"1/6",190,{"v":126.66666666666667,"d":"126.7"},36,"1/3",36,432,660,null,15,{"v":101.33333333333333,"d":"101.3"},"6",{"v":126.66666666666667,"d":"126.7"},3,0.3333333333333333,432]
["Конденсаторные установки 0,4кВ",8,48,"1/4",45,{"v":90,"d":"90.0"},"1/6",32,{"v":42.666666666666664,"d":"42.7"},12,1,28,224,{"v":356.66666666666663,"d":"357"},null,4,{"v":90,"d":"90.0"},"6",{"v":42.666666666666664,"d":"42.7"},1,1,224]
[{"$nulls":13},{"v":1903.4142857142856,"d":"1903"}]
[]
[]
[]
["сумма Трто",3324.053493506493,null,"ЧЭ",4108.17366038961,2.23464989357011,3]
["Трр.х 25%",1306.8669448051946,null,null,1838.3970000000002]
[{"v":0.15,"d":"15%"},784.1201668831168]
[{"$nulls":3},"ЧР",{"v":3210.2812305194802,"d":"3210"},1.9223643792052407,2]
["сумма трудоемк",{"v":7318.45489090909,"d":"7318.45"},null,null,1669.9650000000001]
[]
[]
["Статья баланса","Расчетная величина",{"$nulls":6},"Название должности","Коли-","Для одного ИТР",{"$nulls":3},"Всего в год,",null,null,"Наименование материала","Удельная норма расхода",null,null,"Общий расход","Цена ед., тг.","Общая сумма тыс.тг."]
[null,"Дни","Часы",{"$nulls":6},"чество",{"$nulls":4},"тыс. тг.",{"$nulls":3},"Ед. измерения","Коли-чество"]
["1.     Календарный фонд рабочего времени (Тк)",365,2920,null,8,{"$nulls":4},"человек","Оклад в ме-сяц , тыс. тг.","Премия тыс. тг.","Итого",{"$nulls":4},1,2,3,null,4,5,6]
["2.     Нерабочие дни (Твых + Тпр)",114,912,null,8,{"$nulls":7},"тыс. тг.",{"$nulls":4},"Кол. передаваемой ЭЭ","тыс. кВт∙ч",{"v":120358.28964792292,"d":"120358.29"},null,"-","-","-"]
["3.     Номинальный фонд времени (Тн = Тк – Твых – Тпр)",251,2008,null,8,251,null,null,"Инженер-электрик",1,80,8,88,null,1056,null,null,"Расход материала"]
["4.     Плановые целосменные невыходы:",{"$nulls":3},{"$error":"#DIV/0!"},{"$nulls":3},"Инженер по комплектации электрооборудования",1,70,7,77,null,924,null,null,"Прокат медный","кг/тыс. кВт∙ч",null,0.005,{"v":0.6017914482396146,"d":"0.60"},3500,{"v":2.106270068838651,"d":"2.11"},10.531350344193257]
["а) основные и дополнительные отпуска (Тотп), ",24,192,null,{"$error":"#REF!"},{"$nulls":3},"Инспектор-электрик",1,55,5.5,60.5,null,726,null,null,"Изолента","кг/тыс. кВт∙ч",null,0.018,{"v":2.1664492136626126,"d":"2.17"},800,{"v":1.73315937093009,"d":"1.73"},31.19686867674162]
["б) болезни (Тбол = 1,5% Тн),",3.8,30.4,null,8,3.7649999999999997,null,null,"Итого ФЗП ИТР",{"$nulls":5},2706,null,null,"Предохранители","шт/тыс. кВт∙ч",null,0.09,{"v":10.832246068313063,"d":"10.83"},500,{"v":5.416123034156532,"d":"5.42"},487.4510730740878]
["в) отпуск учащихся (Туч = 1,5% Тн),",3.8,30.4,null,8,{"$nulls":3},"Опф, тыс. тг. -10%ФЗП",{"$nulls":5},270.6,null,null,"Бумага изоляционная","кг/тыс. кВт∙ч",null,0.02,{"v":2.4071657929584585,"d":"2.41"},550,{"v":1.3239411861271522,"d":"1.32"},26.478823722543044]
["г) государственные обязанности (ТГ О = 0,5% Тн)",1.27,10.2,232.6,8,{"$nulls":3},"Соц. Налог, тыс. тг.- 11%(ФЗП- Опф)",{"$nulls":5},297.66,null,null,"Кабель","м",null,1,{"v":120.35828964792293,"d":"120.36"},1500,{"v":180.5374344718844,"d":"180.54"},180537.4344718844]
["5. Эффективный фонд рабочего времени ",218.13,1745,null,8.031496062992126,{"$nulls":3},"ФЗП с отчислениями, тыс. тг.",{"$nulls":5},3274.2599999999998,null,null,"Краска","кг",null,0.09,{"v":10.832246068313063,"d":"10.83"},600,{"v":6.499347640987838,"d":"6.50"},584.9412876889054]
["(Тэ = Тн – Тотп – Тбол – Туч – Тг.о)",{"$nulls":7},"Расчёт фонда заработной платы рабочих",null,null,"Ремонтного",null,"Эксплуатация",{"$nulls":3},"ГСМ","л",null,10,{"v":1203.5828964792292,"d":"1203.58"},90,{"v":108.32246068313063,"d":"108.32"},1083224.6068313064]
["6. Коэффициент использования рабочего времени ",0.87,0.87,{"$nulls":8},"сумма, тыс.тг.",null,"сумма, тыс.тг.",{"$nulls":3},"Итого","-",null,"-","-","-",{"v":305.9387364560553,"d":"305.94"}]
[{"$nulls":8},"Фт",null,null,{"v":1047,"d":"1047.00"},null,1844.16,{"$nulls":3},"Прочее - 10%","-",null,"-","-","-",{"v":30.593873645605534,"d":"30.6"}]
["ремонтники","Фтр",1047000,{"v":1047,"d":"1047.00"},{"$nulls":4},"Доплаты, Фт, тыс. тг - 20%",null,null,209.4,null,368.83200000000005,{"$nulls":3},"Всего ","-",null,"-","-","-",{"v":336.53261010166085,"d":"336.53"}]
["эксплуатация","ФЭр",1844160,1844.16,{"$nulls":4},"Премии, Фт, тыс. тг - 15%",null,null,157.04999999999998,null,276.62]
[{"$nulls":3},2891.16,{"$nulls":4},"Фосн, тыс. тг ",null,null,1413.45,null,{"v":2489.612,"d":"2489.61"}]
[{"$nulls":8},"Фдоп, тыс. тг. -10%",null,null,139.56,null,226.56,null,null,128.62675689744924,0]
[{"$nulls":8},"Фобщ, тыс. тг.",null,null,1553.01,null,{"v":2716.172,"d":"2716.17"}]
[{"$nulls":8},"Оп.ф., тыс. тг. -10%ФЗП ",null,null,{"v":155.30100000000002,"d":"155.30"},null,{"v":271.6172,"d":"271.62"}]
[{"$nulls":8},"Соц. Налог, тыс. тг. 11%",null,null,{"v":155.4795,"d":"155.48"},null,{"v":273.85732,"d":"273.86"}]
[{"$nulls":8},"Социальное страхование, 5%",null,null,{"v":77.65050000000001,"d":"77.65"},null,{"v":135.8086,"d":"135.81"}]
[{"$nulls":8},"Фобщ с отчислениями, тыс. тг.",null,null,{"v":1941.4409999999998,"d":"1941.44"},null,3147.7]
[{"$nulls":8},"Среднемесячная ЗП одного рабочего, тыс. тг.: Фобщ/∙12∙Ч",null,null,{"v":80.89337499999999,"d":"80.89"},null,{"v":87.4361111111111,"d":"87.44"}]
[]
[]
[]
[null,null,"Таблица 2.6"]
[null,null,"Капитальные вложения в строительство линий электропередачи"]
[{"$nulls":3},"Капиталовложения,тыс. тенге","Ед. изм., км","Капитало-",{"$nulls":4},"Таблица 15.7"]
[null,null,"Показатели",null,null,"вложения",{"$nulls":4},"Расчет капитальных затрат"]
[{"$nulls":5},"тыс.тенге",{"$nulls":4},"Элемент электрической сети","Стоимость единицы, тыс. тенге","Ед изм.","Кол-во","Первоначальная стоимость тыс.тг."]
[null,null,"Воздушная линия 35 кВ",320,"2х20",12800,{"$nulls":4},"Трансформаторы 35кВ, 10 МВА",11200,"шт",2,22400,16]
[null,null,"Кабельная линия 10 кВ",350,2.46,861,{"$nulls":4},"Стоимоть ОРУ 35 кВ,  блок линия–трансформатор с выключателем",3000,"шт",1,3000]
[null,null,"Итого капитальные вложения в строительство линий электропередачи ",null,null,13661,{"$nulls":4},"Закрытое распредустройство  ЗРУ-10 кВ, 2 секции ячеек",1200,"шт",20,24000]
[{"$nulls":10},"ТП -10/0,4 кВ (2х1000)",1950,"шт",4,7800]
[{"$nulls":10},"Общие затраты",{"$nulls":3},57200,null,{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"}]
[{"$nulls":10},"Сумма ВЛ+Кап",{"$nulls":3},70861,null,14172.2,7086.1,92119.3]
[]
[]
["Таблица 15.2"]
["Расчет амортизационных отчислений"]
["Элемент электрической сети","Первоначальная стоимость тыс.тг.","Норма амортизации,%","Сумма амортизации тыс.тг."]
["Трансформаторы 35кВ, 10 МВА",22400,6.4,1433.6000000000001]
["Стоимоть ОРУ 35 кВ,  блок линия–трансформатор с выключателем",3000,6.4,192]
["Закрытое распредустройство  ЗРУ-10 кВ, 2 секции ",24000,6.4,1536]
["ТП -10/0,4 кВ (2х1000)",7800,6.4,499.2]
["Воздушная линия 35 кВ",12800,6.4,819.2]
["Кабельная линия 10 кВ",861,4.3,37.022999999999996]
["Общие",70861,2.4,4517.023]
[]
[]
["Таблица 2.9 - Смета годовых затрат на электрохозяйство"]
["Элементы затрат","тыс.тг","Ир.э.о,%"]
["1.     Основная и дополнительная заработная  плата электротехнического персонала",{"v":4539.782,"d":"4539.78"},{"v":43.93141770034318,"d":"43.93"}]
["2.     Социальный налог и соц. страхование",{"v":940.4559200000001,"d":"940.46"},{"v":9.100781017740617,"d":"9.10"}]
["3.     Стоимость вспомогательных материалов ",{"v":336.53261010166085,"d":"336.53"},{"v":3.2566221603069914,"d":"3.26"}]
["4.     Амортизационные отчисления",4517.023,{"v":43.7111791216092,"d":"43.71"}]
["Итого: годовые затраты на электрохозяйство",{"v":10333.793530101662,"d":"10333.79"},{"v":99.99999999999999,"d":"100.00"}]
[]
["Таблица 2.10 - Себестоимость 1 кВт×ч электроэнергии"]
["Статья расходов","Ед. изм.","Кол-во"]
["1.     Годовое потребление активной электроэнергии","тыс.кВт×ч",{"v":120358.28964792292,"d":"120358.29"}]
["2.     Заявленный максимум мощности ","тыс.кВт",{"v":16.04777195305639,"d":"16.05"}]
["3.     Плата по тарифу за активную энергию","   тыс.кВт×",{"v":1444299.4757750751,"d":"1444299.48"}]
["4.     Годовое потребление реактивной энергии","тыс.квар ч",{"v":0,"d":"0.00"}]
["5.     Плата по тарифу за реактивную энергию","тыс.тг.",{"v":0,"d":"0.00"}]
["6.     Итого: стоимость полученной электроэнергии ","тыс.тг.",{"v":1444299.4757750751,"d":"1444299.48"}]
["7.     Годовые затраты на общезаводскую часть электрохозяйства","тыс.тг.",{"v":10333.793530101662,"d":"10333.79"}]
["8.     Всего производственные расходы ","тыс.тг.",{"v":1454633.2693051768,"d":"1454633.27"}]
["9.      Расход электроэнергии на собственные нужды и потери в оборудовании и сетях (4-5%)","тыс.кВт×ч",{"v":4814.331585916917,"d":"4814.33"},0.6419108781222557]
["10.            Полезно используемая электроэнергия ","тыс.кВт×ч",{"v":115543.958062006,"d":"115543.96"}]
["11. Производственная себестоимость потребленной электроэнергии ","     тыс.тг",{"v":12.589436035457226,"d":"12.59"},{"v":4.439436035457225,"d":"4.44"}]
[]
[]
["Наименование показателя","Обозначение","Ед. измерения","Количество"]
["1.     Установленная мощность электроприемников предприятия","Ру","кВт",{"v":30069.35904,"d":"30069.36"}]
["2.     Среднесменная мощность","Рсм","кВт",{"v":17724.483985600004,"d":"17724.48"}]
["3.     Коэффициент использования","Кисп","о.е",{"v":0.5304806473226951,"d":"0.53"}]
["4.     Число часов использования","Тмакс","ч",7500]
["5.     Годовое потребление электроэнергии","Wг","кВт×ч",120358.28964792292]
["6.     Потери электроэнергии","DW","кВт×ч",{"v":4814.331585916918,"d":"4814.33"}]
["7.     Стоимость потребленной электроэнергии","Цэ","тыс.тг",{"v":1444299.4757750751,"d":"1444299.48"}]
["8.     Объем эксплуатационно-ремонтных работ","ΣТР.Р.С","чел.ч",{"v":1903.4142857142856,"d":"1903"}]
["9.     Затраты на ремонтно-эксплуатационное обслуживание электрохозяйства","Ирэо","тыс.тг",{"v":10333.793530101662,"d":"10334"}]
["10.           Производственная себестоимость ","Цэ","тг/кВт×ч",{"v":12.589436035457226,"d":"12.59"}]

{"sheet":"РЗ","index":20,"n_rows":11,"n_cols":14,"rows_kept":11,"flags":["formulas_cached_only"]}
[{"$nulls":12},"Кз 6 кВ"]
["S","U1","U2","I1","I2","ток КЗ 35",{"$nulls":6},6180]
[10000,110,6,{"v":52.54860746190226,"d":"52.55"},{"v":963.3911368015415,"d":"963.39"},{"v":4.714,"d":"4.71"},{"v":315.29164477141353,"d":"315.29"},{"v":5.254860746190226,"d":"5.25"},{"v":12.962722190000003,"d":"12.96"},{"v":5780.346820809248,"d":"5780.35"},{"v":28.90173410404624,"d":"28.90"},24.1,4820,{"v":1.111630705394191,"d":"1.11"}]
[]
["перегрузка 6 кв"]
[1.2,0.8,1445.086705202312,{"v":7.22543352601156,"d":"7.23"},{"v":3.7208750000000004,"d":"3.72"}]
[]
["отсечка  нн"]
[6180,8652,43.26,{"v":1059.4285714285716,"d":"1059.43"}]
[1980,2772,13.86]
[{"v":1059.4285714285716,"d":"1059.43"},1483.2,7.416,null,{"v":1.1599054054054054,"d":"1.16"}]

{"sheet":"Заземление","index":21,"n_rows":15,"n_cols":9,"rows_kept":15,"flags":["formulas_cached_only"]}
["Уд сопротивление суглинок","коэф"]
[100,2,1.15,200,114.99999999999999]
[]
["горизонт заземлители"]
["l","b","t"]
[156,0.04,0.8,0.46923076923076923,1521000,6.182129214052997,2.900845246594099,0.48,6.043427597071039]
["l","d","t","вертикальные"]
[5,0.02,3.3]
[null,35,20.15,350,2.015,62.034739454094286]
[null,6,2,350,1.2,104.16666666666667]
[]
["Вертикальные искомое"]
[11.829981362165075,8.418,null,2.6989700043360183,18.2,8.2,0.8656438390033954,30.006919333231185]
[]
[{"$nulls":4},3.8423115346192267]